Skip to main content
Version: Stable-3.1

week_iso

Description​

Returns the ISO standard week of the year for the specified date as an integer within the range of 1 to 53.

Syntax​

INT WEEK_ISO(DATETIME date)

Parameters​

date: the date you want to convert. It must be of the DATE or DATETIME type.

Examples​

The following example returns the ISO standard week of the year for the date 2008-02-20 00:00:00:

MySQL > select week_iso ('2008-02-20 00:00:00');
+-----------------------------------+
| week_iso('2008-02-20 00:00:00')   |
+-----------------------------------+
|                                 8 |
+-----------------------------------+

Keywords​

WEEK_I