TO_WEEK_OF_YEAR

Introduced or updated: v1.2.151

Calculates the week number within a year for a given date.

ISO week numbering works as follows: January 4th is always considered part of the first week. If January 1st is a Thursday, then the week that spans from Monday, December 29th, to Sunday, January 4th, is designated as ISO week 1. If January 1st falls on a Friday, then the week that goes from Monday, January 4th, to Sunday, January 10th, is marked as ISO week 1.

Syntax

TO_WEEK_OF_YEAR(<expr>)

Arguments

Arguments	Description
<expr>	date/timestamp

Return Type

Returns an integer that represents the week number within a year, with numbering starting from 1.

Examples

SELECT TO_WEEK_OF_YEAR('2017-01-01');
----
52

SELECT TO_WEEK_OF_YEAR('2016-01-02T23:39:20.123-07:00');
----
53

SELECT TO_WEEK_OF_YEAR('2023-05-01');
----
18