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

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

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 2025-04-28 17

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

This article is written by plus2net.com team. https://www.plus2net.com

plus2net.com