Skip to content

Returns the ISO day of the week index for a date (1=Monday, 7=Sunday).

func.dayofweek_iso(<date>)
func.dayofweek_iso('2024-06-15')
┌───┐
│ 6 │
└───┘
DAYOFWEEK_ISO(<date>)
SELECT DAYOFWEEK_ISO('2024-06-15');
┌───┐
│ 6 │
└───┘