MySQL YEARWEEK Function

Example

Return the year and week number for a date:

SELECT YEARWEEK("2017-06-15");

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:

  • 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: From MySQL 4.0

More Examples

Example

Return the year and week number for a date:

SELECT YEARWEEK("2017-10-25");

Example

Return the year and week number for the current system date:

SELECT YEARWEEK(CURDATE());