Retrieve the hour from a specified time.
SELECT Hour(#14:48:23#); |
The Hour() function retrieves the hour component from a time or datetime value, returning an integer between 0 and 23.
Hour(time) |
Parameter |
Description |
time |
Required. A numeric or string expression that represents a valid time or datetime value. |
WORKS IN |
From Access 2000 |
Retrieve the hour of the current time.
SELECT Hour(Now()); |
Retrieve the hour from a specified datetime.
SELECT Hour(#24/10/2016 11:18:34 PM#); |