MySQL WEEK() Function
❮ MySQL Functions
Example
Return the week portion of a date:
SELECT WEEK("2017-06-15");
Try it Yourself »
Definition and Usage
The WEEK() function returns the week portion of a date value (a number from 0 to
53).
Syntax
Parameter Values
| Parameter |
Description |
| date |
Required. The date or datetime value from which to extract the
week |
| mode |
Optional. Specifies what day the week starts on. Can be one of the
following:
- 0 - First day of week is Sunday
- 1 - First day of week is Monday and the first week has more than 3
days
- 2 - First day of week is Sunday
- 3 - First day of week is Monday and the first week has more than 3
days
- 4 - First day of week is Sunday and the first week has more than 3
days
- 5 - First day of week is Monday
- 6 - First day of week is Sunday and the first week has more than 3
days
- 7 - First day of week is Monday
|
Technical Details
| Works in: |
MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL
4.0, MySQL 3.23 |
More Examples
Example
Return the week portion of a date:
SELECT WEEK("2017-10-25");
Try it Yourself »
Example
Return the week portion of the current system date:
SELECT WEEK(CURDATE());
Try it Yourself »
❮ MySQL Functions
