MySQL WEEK() 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 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

WEEK(date, mode)

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