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 2024-03-19 11

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 )
Subscribe to our YouTube Channel here


Subscribe

* indicates required
Subscribe to plus2net

    plus2net.com

    Post your comments , suggestion , error , requirements etc here





    SQL Video Tutorials










    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2024 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer