Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
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 |
+-----------------------+
