MySQL WEEKOFYEAR() Function
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 |
---|
More Examples
Example
Return the week number for the current system date:
SELECT WEEKOFYEAR(CURDATE());
Try it Yourself »