Get started
Load & manage data
Work with data
Administration
Reference & resources
CLUSTER BY
mask
ROW FILTER
Updated Feb 07, 2025
Send us feedback
weekday
Applies to: Databricks SQL Databricks Runtime
Returns the day of the week of expr. This function is a synonym for extract(DAYOFWEEK_ISO FROM expr) - 1.
expr
extract(DAYOFWEEK_ISO FROM expr) - 1
weekday(expr)
expr: A DATE or TIMESTAMP expression.
An INTEGER where 0 = Monday and 6 = Sunday.
> SELECT weekday(DATE'2009-07-30'), extract(DAYOFWEEK_ISO FROM DATE'2009-07-30'); 3 4
day function
dayofmonth function
dayofyear function
extract function
dayofweek function