dayofweek

Returns the day of the week in "date_expression" as an integer (1-7), where 1 represents Monday.

dayofweek ( date_expression )