WEEKOFYEAR(): function in a mysql date and time fieldReturns the Week Number of the year from a date .
Output is 34
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