MONTH

MONTH(date)

Extracts the month component from a date or array of dates.

The MONTH function returns the month from the provided date. It supports both single dates and arrays of dates, returning an integer or an integer array accordingly.

Parameters:

date (Operand) – The date or array of dates from which to extract the month.

Return type:

Formula

Returns:

The month as an integer or array of integers.

Raises:

ValueError – If the input is not a date or datetime type.

Examples

MONTH(DATE(2025, 9, 3))
# Returns 9

``value`` — accepted types

• DATE

• DATETIME

• DATETIME_ARRAY

• DATE_ARRAY

Return types

• INTEGER

• INTEGER_ARRAY