HOUR
Returns the hour of the day from a timestamp.
Values range from 0 to 23.
Syntax
HOUR(timestamp)
Arguments
| Name | Type | Description | Default Value |
|---|---|---|---|
| timestamp | timestamp |
Returns
bigint
Examples
| timestamp | Output |
|---|---|
| timestamp "2018-03-10 08:55:12.456" | 8 |