MySQL YEARWEEK() Function
THE WORLD'S LARGEST WEB DEVELOPER SITE
HTML CSS JAVASCRIPT SQL PHP BOOTSTRAP HOW TO JQUERY W3.CSS ANGULAR XML MORE FORUM EXAMPLES REFERENCES

MySQL YEARWEEK() Function

❮ MySQL Functions

Example

Return the year and week for a date:

SELECT YEARWEEK("2017-06-15");
Try it Yourself »

Definition and Usage

The YEARWEEK() function returns the year and week for a date (a number from 0 to 53).

Syntax

YEARWEEK(date, mode)

Parameter Values

Parameter Description
date Required.  The date or datetime value from which to extract the year and 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 year and week for a date:

SELECT YEARWEEK("2017-10-25");
Try it Yourself »

Example

Return the year and week for the current system date:

SELECT YEARWEEK(CURDATE());
Try it Yourself »

❮ MySQL Functions