YEARWEEK() MySQL function to return Year and YEARWEEK number of the year from 0 to 53

SELECT YEARWEEK('2023-01-02'); #202301
SELECT YEARWEEK('2023-12-31'); #202353
SELECT YEARWEEK('2024-01-01'); #202353

Syntax

YEARWEEK(date,[mode])

Example

SELECT YEARWEEK('2016-09-23')

Output is 201638
For a invalid date we will get Null as output

SELECT YEAR('2010-02-31')

Output is NULL
DEMO: Select date from Calendar to execute YEARWEEK()

Understanding Mode (Optional Parameter , value 0 to 7)

The week can start on Sunday or Monday,
To understand uses of MODE, read WEEK() function
If mode is not given, then it is considered as 0. The default_week_format of the MySQL system variables is not considered in YEARWEEK() function like WEEK() function. This is the main difference while using MODE between WEEK() function and YEARWEEK() function.

2012-01-01 change the First Day of Week to Monday
2018-01-01 select Sunday as First Day of Week
SQL Date References WEEK() : Week number of year ( 0 to 53 ) WEEKDAY() : 0 for Monday .. 6 for Sunday

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

YEARWEEK(): Year & Week from input date

Understanding Mode (Optional Parameter , value 0 to 7)

Subhendu Mohapatra