DAYOFWEEK_ISO

Returns an INTEGER representing the ISO 8061 day of the week based on a VARCHAR, DATE, or TIMESTAMP input value. Valid return values are:

* 1 Monday
* 2 Tuesday
* 3 Wednesday
* 4 Thursday
* 5 Friday
* 6 Saturday
* 7 Sunday

Syntax

DAYOFWEEK_ISO ( date )