weekofyear function (Databricks SQL)

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