Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns the hour component of a TIMESTAMP value.
HOUR( timestamp-expression )
A TIMESTAMP value.
The value returned is the hour portion of the TIMESTAMP expression, a SMALLINT value between 0 and 23.
The following statement returns the value 21:
SELECT HOUR( '1998-07-09 21:12:13' );