dayname

Returns the day corresponding to a date.

The date parameter must be of the DATE or DATETIME type.

Syntax

Haskell

VARCHAR DAYNAME(date)

Examples

Plain

MySQL > select dayname('2007-02-03 00:00:00');
+--------------------------------+
| dayname('2007-02-03 00:00:00') |
+--------------------------------+
| Saturday                       |
+--------------------------------+

keyword

DAYNAME