Mobile DBMS version: this function is not permitted with DB2.
Syntax
HOUR(Argument)
Description
The HOUR SQL scalar function returns the hour part of a value.
The argument must be a time, or a timestamp.
The result of the function is an integer.
If the argument can be null, the result can be null; if the argument is null, the result is the null value.
If the argument is a time or timestamp, the result is the hour part of the value, which is an integer between 0 and 24.
Example
Assume ORDER_HOUR is 12 hours 35 minutes and 15 seconds
HOUR(ORDER_HOUR) returns 12
List of SQL scalar functions by topic