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 )