SQL•SQL References

MySQL MONTHNAME() Function

Example

SELECT MONTHNAME("2017-06-15");

Definition and Usage

The MONTHNAME() function returns the name of the month for a given date.

Syntax

MONTHNAME(
date
)

Parameter	Description
date	Required. The date or datetime value to extract the month name from

Works in:	From MySQL 4.0

Loading lesson path

SQL•SQL References

Example

SELECT MONTHNAME("2017-06-15");

The MONTHNAME() function returns the name of the month for a given date.

Syntax

MONTHNAME(
date
)

Parameter	Description
date	Required. The date or datetime value to extract the month name from

Works in:	From MySQL 4.0