Functions/Dates & time/dayofweek
Dates & time Scalar

dayofweek()

Extract the dayofweek component from a date or timestamp

Arguments & returns

4 overloads

dayofweek(ts)

Scalar
Overload link ts Returns
#01 DATE BIGINT
#02 INTERVAL BIGINT
#03 TIMESTAMP BIGINT
#04 TIMESTAMP WITH TIME ZONE BIGINT

Example

dayofweek example
SQL
Haybarn WASM 1.5.6-rc6 · In your browser

Engine example · Run to view results.