MONTHNAME

Retrieve the name of the month corresponding to a given date.

SELECT MONTHNAME(“2017-06-15”);

Definition and Usage

The MONTHNAME() function retrieves the name of the month based on a provided date.

MONTHNAME(date)

Parameter	Description
date	Mandatory: The date or datetime value from which to retrieve the month name.

Works in:

From MySQL version 4.0

SELECT MONTHNAME(“2017-06-15 09:34:21”);

Retrieve the name of the month for the current system date.

SELECT MONTHNAME(CURDATE());