Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: Databricks SQL
Databricks Runtime
Returns the week of the year of expr
.
weekofyear(expr)
expr
: A DATE expression.
An INTEGER.
A week is considered to start on a Monday and week 1 is the first week with >3 days.
This function is a synonym for extract(WEEK FROM expr)
.
> SELECT weekofyear('2008-02-20');
8