WEEKOFYEAR(): function in a mysql date and time field
Output is 34
By using CURDATE() we can get present week number of the year.
For a invalid date we will get Null as output
Output is NULL
WEEKDAY() function to get number from 0 to 6 based on Weekday in MySQL
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. https://www.plus2net.com
▼ More on Date & Time functions in SQL