WEEKDAY
Extracts the day of the week from a date. Monday is 0, Tuesday is 1, etc.
Syntax
WEEKDAY (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 WEEKDAY('2014-04-18'); **** +-----------------------+ | WEEKDAY('2014-04-18') | +-----------------------+ | 4 | +-----------------------+
Related Topics