MONTH
Description
Returns the month component (1=January) from a Date or Datetime, evaluated in the context user's local time zone.
Syntax
MONTH(date/datetime) -> Integer
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| date/datetime | Date/Datetime | Yes | The Date or Datetime to extract the month from. |
Examples
MONTH(DATE(2024, 1, 25))
-- Returns 1.MONTH(TO_DATETIME("2024-08-15T14:45:00.000Z"))
-- Returns 8.