DAYOFWEEKISO

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

DAYOFWEEKISO( <date_or_timestamp_expr> ) Day (number) of the week uses ISO semantics 1 to 7

> select DAYOFWEEKISO(tstamp) AS "DAYOFWEEKISO" from ( SELECT '2016-01-02T23:39:20.123-07:00'::TIMESTAMP AS tstamp)
6

Last modified on November 3, 2026