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.

MONTHNAME

Extracts the name of the month from the given datetime.

Syntax

MONTHNAME ( dateobj )

Arguments

  • dateobj: a valid date, datetime, or parsable date string.

Return Type

String

Examples

memsql> select monthname('2009-02-13 23:31:30');
+----------------------------------+
| monthname('2009-02-13 23:31:30') |
+----------------------------------+
| February                         |
+----------------------------------+

Related Topics