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
For a invalid date we will get Null as output

SELECT WEEKOFYEAR('2015-02-31')

Output is NULL Monday is the starting day of the week.
This function is same as WEEK() function when mode is equal to 3

Your Rating

▼ Date & Time functions in SQL