VeloDB Cloud
SQL Manual
Functions
date-time-functions
monthname

monthname

Description

Syntax:

VARCHAR MONTHNAME (DATE)

This function returns the month name of the given date.

The parameter is of DATE or DATETIME type.

Example

mysql> select monthname('2008-02-03 00:00:00');
+----------------------------------+
| monthname('2008-02-03 00:00:00') |
+----------------------------------+
| February                         |
+----------------------------------+

Keywords

MONTHNAME