Loading lesson path
Concept visual
Start at both ends
Return the name of the month for a date:
SELECT MONTHNAME("2017-06-15");The MONTHNAME() function returns the name of the month for a given date.
date )
Required. The date or datetime value to extract the month name from
From MySQL 4.0
Return the name of the month for a date: SELECT MONTHNAME("2017-06-15 09:34:21");
Return the name of the month for the current system date:
SELECT MONTHNAME(CURDATE());❮ MySQL Functions