WEEKOFYEAR(): function in a mysql date and time fieldReturns the Week Number of the year from a date .Syntax
Example
Output is 34By using CURDATE() we can get present week number of the year.
For a invalid date we will get Null as output
Output is NULL
Monday is the starting day of the week. This function is same as WEEK() function when mode is equal to 3
This article is written by plus2net.com team.
![]() ▼ More on Date & Time functions in SQL |