WEEK()

All functions > DATE AND TIME > WEEK()

Returns the week component of a date or timestamp.

Signatures

Returns: The week component

WEEK(timestamp: T) → BIGINT

With:

• T : Custom types: DATE | TIMESTAMP

Notes

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

Examples

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