Function Description
| Category | Description |
|---|---|
| Syntax | HOUR(time) |
| Function | Returns the hour value from a specified time. |
| Parameter | time: a specified time value Only date or datetime values are supported. |
| Number of Parameters | 1 |
| Parameter Type | Date or datetime |
| Return Value Type | Number from 0 to 23 |
Examples
| Formula | Result |
|---|---|
HOUR(TIME(8,1,2)) | 8 |
HOUR(TODATE("2000-01-01 09:03:04")) | 9 |
More Examples
For example, you can use HOUR to get the hour value from Order Start Time.
