GETDAYOFWEEK

GETDAYOFWEEK() AS INTEGER

Returns the current day of week: Sunday is 0, Monday is 1, and so on.