WEEKDAY

WEEKDAY(x) the day of the week (where Monday is weekday 1) corresponding to data-time value x.