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
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for