Example
Return the year and week number for a date:
SELECT YEARWEEK("2017-06-15");
Definition and Usage
The YEARWEEK() function returns the year and week number (a number from 0 to 53) for a given date.
Syntax
YEARWEEK(date, firstdayofweek)
Return the year and week number for a date:
SELECT YEARWEEK("2017-06-15");
The YEARWEEK() function returns the year and week number (a number from 0 to 53) for a given date.
YEARWEEK(date, firstdayofweek)