Returns the hour component of a TIMESTAMP value.
HOUR( timestamp-expression )
timestamp-expression A TIMESTAMP value.
SMALLINT
The value returned is the hour portion of the TIMESTAMP expression, a SMALLINT value between 0 and 23.
SQL/2008 Vendor extension.
The following statement returns the value 21:
SELECT HOUR( '1998-07-09 21:12:13' );