SECOND

Returns the seconds in the argument as a short integer value in the range of 0-59.

Syntax

SECOND ( time_expression )

Notes

The argument to the function must be of type TIME.

The argument must be specified in the format HH:MI:SS.

The result is of type SHORT.

If the argument expression evaluates to NULL, the result is NULL.

Example

This example illustrates the SECOND function, requesting all columns from rows in the arrivals table where the in_time column is less than or equal to ‘40':

SELECT * FROM arrivals WHERE SECOND (in_time) <= 40 ;

Compatibility

ODBC compatible