Progress
SQL-92
Guide and Reference


HOUR FUNCTION

Returns the hour in the argument as a short integer value in the range of 0-23.

SYNTAX

HOUR ( time_expression ) 

EXAMPLE

This example illustrates the HOUR function:

SELECT *
    FROM arrivals
    WHERE HOUR (in_time) < 12 ; 

NOTES

COMPATIBILITY

ODBC Compatible


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