Retrieve the name of the month corresponding to a given date.
| SELECT MONTHNAME(“2017-06-15”); |
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()); |