YEAR()

All functions > DATE AND TIME > YEAR()

Returns the year component of a date or timestamp.

Signatures

Returns: The year component

YEAR(timestamp: T) → BIGINT

With:

• T : Custom types: DATE | TIMESTAMP

Notes

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

Examples

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