weekofyear function

Applies to: check marked yes Databricks SQL check marked yes 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