ASA SQL Reference
SQL Functions
Alphabetical list of functions
Returns a number from 0 to 23 corresponding to the hour component of a datetime.
HOUR ( datetime-expression )
datetime-expression The datetime.
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Not supported by Adaptive Server Enterprise.
The following statement returns the value 21:
SELECT HOUR( '1998-07-09 21:12:13' )