You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

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

memsql> select dayname('2014-04-18');
+-----------------------+
| dayname('2014-04-18') |
+-----------------------+
| Friday                |
+-----------------------+