Progress
SQL-92
Guide and Reference


SECOND Function

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

SYNTAX

SECOND ( time_expression ) 

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 ; 

NOTES

COMPATIBILITY

ODBC Compatible


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095