| 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