isodow()

Extract the isodow component from a date or timestamp

Arguments & returns

4 overloads

Scalar

SELECT isodow(timestamp '2021-08-03 11:59:44.123456');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

DAY_OF_WEEK(CAST('2012-08-08 01:00:00' AS TIMESTAMP))

In DuckDB

ISODOW(CAST('2012-08-08 01:00:00' AS TIMESTAMP))

DAYOFWEEKISO(foo)

In DuckDB

ISODOW(foo)