Name

MONTHNAME()

Synopsis

MONTHNAME(date)

Returns the full name of the month for date. This code returns the string “July”:

SELECT MONTHNAME('2012-07-11');

Get Learning PHP, MySQL, and JavaScript now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.