QUARTER()

All functions > DATE AND TIME > QUARTER()

Returns the quarter component of a date or timestamp.

Signatures

Returns: The quarter component

QUARTER(timestamp: T) → BIGINT

With:

• T : Custom types: DATE | TIMESTAMP

Notes

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

Examples

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