weekofyear function
Applies to: 
Databricks SQL Databricks Runtime
Returns the week of the year of expr.
Syntax
weekofyear(expr)
Arguments
expr: A DATE expression.
Returns
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).
Examples
> SELECT weekofyear('2008-02-20');
8