HOUR
Description
Extracts the hour (0–23) from a Datetime value, based on the context user’s local time zone.
Syntax
HOUR(datetime) -> Integer
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| datetime | Datetime | Yes | The Datetime value from which the hour is extracted |
Example
HOUR(NOW())
-- Returns 8 (if now = 2024-09-18T15:25:22.418Z and user is in PDT).