day_of_week_iso

dayofweek_iso

Description

Returns the ISO standard weekday number for a given date.

The date parameter must be of the DATE or DATETIME type.

Syntax

INT DAY_OF_WEEK_ISO(DATETIME date)

Examples

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

keyword

DAY_OF_WEEK_ISO