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
