Example
SELECT WEEKOFYEAR("2017-06-15");Definition and Usage
The WEEKOFYEAR() function returns the week number for a given date (a number from 1 to 53).
Note
This function assumes that the first day of the week is Monday and the first week of the year has more than 3 days.
Tip
Also look at the WEEK() function.
Syntax
WEEKOFYEAR(
date
)Parameter Values
| Parameter | Description |
|---|---|
| date | Required. The date or datetime to extract the week number from |
Technical Details
| Works in: | From MySQL 4.0 |
|---|