Outdated Version

You are viewing an older version of this section. View current production version.

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                |
+-----------------------+