MySQL MONTHNAME() Function

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP







<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]
-->



MySQL MONTHNAME() Function



❮ MySQL Functions



Example


Return the name of the month for a date:



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

Try it Yourself »

Definition and Usage


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



Syntax



MONTHNAME(date)


Parameter Values





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

Technical Details




Works in: From MySQL 4.0

More Examples



Example


Return the name of the month for a date:



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

Try it Yourself »



Example


Return the name of the month for the current system date:



SELECT MONTHNAME(CURDATE());

Try it Yourself »


❮ MySQL Functions


-