iso_week datepart
statementsISO 8601 includes the ISO week-date system, a numbering system for weeks. Each week is
associated with the year in which Thursday occurs. For example, week 1 of 2004 (2004W01)
covered Monday, 29 December 2003 to Sunday, 4 January 2004. European countries/regions
typically use this style of numbering. Non-European countries/regions typically don’t use it.
Note: the highest week number in a year could be either 52 or 53.
The numbering systems of different countries/regions might not comply with the ISO standard.
This table shows six possibilities:
Sunday
1 January,
First Saturday,
1-7 days of year
Yes
United States
Monday
1 January,
First Sunday,
1-7 days of year
Yes
Most of Europe and the United
Kingdom
Monday
4 January,
First Thursday,
4-7 days of year
No
ISO 8601, Norway, and Sweden
Monday
7 January,
First Monday,
Seven days of year
No
Wednesday
1 January,
First Tuesday,
1-7 days of year
Yes
Saturday
1 January,
Yes
Expand table