MySQL YEARWEEK() Function
Example
Return the year and week number for a date:
SELECT YEARWEEK("2017-06-15");
Try it Yourself »
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)
Parameter Values
| Parameter | Description |
|---|---|
| date | Required. The date or datetime value to extract the year and week number from |
| firstdayofweek |
Optional. Specifies what day the week starts on. Can be one of the following:
|
Technical Details
| Works in: | From MySQL 4.0 |
|---|
More Examples
Example
Return the year and week number for a date:
SELECT YEARWEEK("2017-10-25");
Try it Yourself »
Example
Return the year and week number for the current system date:
SELECT YEARWEEK(CURDATE());
Try it Yourself »
