WEEKOFYEAR(): function in a mysql date and time field
Returns the Week Number of the year from a date .
Syntax
WEEKOFYEAR(date)
Example
SELECT WEEKOFYEAR('2015-08-21')
Output is 34
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
Video Tutorial on Date Query using CURDATE, BETWEEN , YEAR, MONTH, DAYOFWEEK()-
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
plus2net.com
▼ More on Date & Time functions in SQL
|
SQL Video Tutorials