Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Functions : SECOND
 

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