version 11
HOUR (arithmetic_expression)
Description
The HOUR function returns the hour part of the time passed in the arithmetic_expression. The value returned ranges from 0 to 23.
Example
Supposing that we have the INVOICES table with a Delivery_Time field. To display the hour of the delivery time:
SELECT HOUR(Delivery_Time) FROM INVOICES;
See Also