DAYOFWEEK
Extracts the day of the week from a date. Sunday is 1, Monday is 2, etc.
Syntax
DAYOFWEEK (dateobj)
Arguments
dateobj: a valid date, datetime, or parsable date string.
Return Type
Integer. If dateobj is not a valid date, returns NULL.
Examples
SELECT DAYOFWEEK('2014-04-18');
+-------------------------+ | DAYOFWEEK('2014-04-18') | +-------------------------+ | 6 | +-------------------------+