DAYNAME
Extracts the name of the day of the week from a date.
Syntax
DAYNAME (dateobj)
Arguments
dateobj: a valid date, datetime, or parsable date string.
Return Type
String. If dateobj is not a valid date, returns NULL.
Examples
SELECT DAYNAME('2014-04-18'); **** +-----------------------+ | DAYNAME('2014-04-18') | +-----------------------+ | Friday | +-----------------------+