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