WEEKOFYEAR() MySQL function to return week number of the year (1 , 53)

SELECT WEEKOFYEAR('2024-01-01'); # 1
SELECT WEEKOFYEAR('2024-01-04'); # 1
SELECT WEEKOFYEAR('2024-12-28'); # 52
SELECT WEEKOFYEAR('2024-12-31'); # 1

Syntax

WEEKOFYEAR(date)

Example

SELECT WEEKOFYEAR('2015-08-21')

Output is 34

SELECT CURDATE() dt1, WEEKOFYEAR(CURDATE()) dt2

Output is 2026-09-09 36

By using CURDATE() we can get present week number of the year.

SELECT WEEKOFYEAR( CURDATE( ) )

For a invalid date we will get Null as output

SELECT WEEKOFYEAR('2015-02-31')

Output is NULL

WEEKDAY() function to get number from 0 to 6 based on Weekday in MySQL

DEMO: Select date from Calendar to execute WEEKOFYEAR()
Monday is the starting day of the week.
This function is same as WEEK() function when mode is equal to 3
SQL Date WEEK() : Week Number in Year( 0 to 53 )

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

WEEKOFYEAR(): Week Number of the year from input date

Subhendu Mohapatra