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

Related functions

• day function
• dayofmonth function
• dayofyear function
• extract function
• dayofweek function