MONTH()

All functions > DATE AND TIME > MONTH()

Returns the month component of a date or timestamp.

Signatures

Returns: The month component

MONTH(timestamp: T) → BIGINT

With:

• T : Custom types: DATE | TIMESTAMP

Notes

• Permissive spelling of DATE_PART(timestamp, 'month')
• Also accepts TIMESTAMP

Examples

RETURN
    -- Extract month
    f1 := DATE_PART(DATE '2024-03-15', 'month')
;