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