Skip to main content
Version: Latest-3.5

dayofweek_iso

Returns the ISO standard day of the week for the specified date as an integer within the range of 1 to 7. In this standard, 1 represents Monday, and 7 represents Sunday.

Syntax​

INT DAY_OF_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 day of the week for the date 2023-01-01:

MySQL > select dayofweek_iso('2023-01-01');
+-----------------------------+
| dayofweek_iso('2023-01-01') |
+-----------------------------+
|                           7 |
+-----------------------------+

Keywords​

DAY_OF_WEEK_ISO