WEEKISO

This function isn’t in the updated function reference yet. The details below come from the previous docs, and the product team is confirming them.

Syntax

WEEKISO( <date_or_timestamp_expr> ) WEEKISO is the same as WEEKOFYEAR, except uses ISO semantics 1 to 53.

> SELECT WEEKISO(tstamp) AS "WEEK ISO" FROM (SELECT  '2016-01-02T23:39:20.123-07:00'::TIMESTAMP AS tstamp)
53

Last modified on November 3, 2026