SQL HOUR() Function

SQL HOUR() Syntax

The below syntax is used to get hour of the day value (a integer number between 0 to 23, inclusive) from a given input datetime value.

For SQL SERVER / MY SQL / MS ACCESS

SELECT HOUR('valid_datetime_value' or 'valid_timestamp_value');

SQL HOUR() Example - Using Expression Or Formula

The following SQL SELECT statement will extract the hour of the day value from a given input datetime value. We use now() function to get the input date value.

SELECT 
NOW() AS 'Current Date and Time', 
HOUR(NOW()) AS 'Hour Value';

The result of above query is:

Sample Database Table - BookOrder

SQL HOUR() Example - With Table Column

The following SQL SELECT statement display the column "OrderDate" and "DeliveryDate" from the "BookOrder" table. The HOUR() function will extract the HOUR value(a whole integer number from 1 to 24) from the column "OrderDate" and we will stored that value to a new column called "Order HOUR" and "Delivery HOUR".

SELECT 
OrderDate, HOUR(OrderDate) As 'Order HOUR', 
DeliveryDate, HOUR(DeliveryDate) As 'Delivery HOUR' 
FROM BookOrder;

The result of above query is: