dayname
Description
Returns the day corresponding to a date.
The date
parameter must be of the DATE or DATETIME type.
Syntax
VARCHAR DAYNAME(date)
Examples
MySQL > select dayname('2007-02-03 00:00:00');
+--------------------------------+
| dayname('2007-02-03 00:00:00') |
+--------------------------------+
| Saturday |
+--------------------------------+
keyword
DAYNAME