DAY_IN_WEEK

Returns a number representing the day of the week for "date_expression" 1 for Sunday, 7 for Saturday.

DAY_IN_WEEK ( date_expression )

DAY_IN_WEEK ( '2012-02-29' )