SECOND

Restriction: This topic applies to Windows environments only.

ANSI	DB2	SQL/DS	XDB
	X		X

This function is used to extract the seconds part of a time or timestamp. The result is an integer between 0 and 59 (or null if time-expr evaluates to a null value). The format appears below:

SECOND(time-expr)

For example:

SELECT SECOND(endtime)
FROM tasks