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.

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

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

Related Topics