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_ISO