MONTHNAME( )

This MySQL function returns the name of the month for the date provided.

Syntax

Below is the syntax for this command. Text within square brackets (i.e, [ and ] ) are optional. Choices are separated by bars (i.e, | ). Ellipses preceded by a comma indicates a repeating pattern. Ellipses before or after syntax are used to highlight a relevant except from the larger syntax. Text displayed in italic letters represent text that should be replaced with the specific names related to the database (e.g., column with the name of the column).

MONTHNAME(date)

Explanation

This function returns the name of the month for the date provided. As of MySQL version 5.1.15, the lc_time_names system variable is used to determine the actual set of names to use. Use the SET statement to change this variable. See MySQL's documentation page on MySQL Server Locale Support (http://dev.mysql.com/doc/refman/5.1/en/locale-support.html) for a list of locale values available for time names.

Examples

SELECT appointment AS 'Appointment',
MONTHNAME(appointment) AS 'Month of Appointment'
FROM appointments
WHERE client_id = '8302'
AND appointment > NOW( );

+-------------+----------------------+
| Appointment | Month of Appointment |
+-------------+----------------------+
| 2008-03-15  | March                | 
+-------------+----------------------+

SET lc_time_names = 'it_IT';

+-------------+----------------------+
| Appointment | Month of Appointment |
+-------------+----------------------+
| 2008-03-15  | marzo                | 
+-------------+----------------------+

In this example, the client has only one appointment after the current date, and it's in March. After setting the lc_time_names variable to 'it_IT' (i.e., italian, Italy), the results returned for the same SQL statement are given in Italian. You can use this function in conjunction with a function such as CONCAT() to paste the results into other text or to create a style you prefer.

SELECT CONCAT('Il tuo appuntamento è in ', MONTHNAME(appointment), '.') 
AS 'Reminder'
FROM appointments
WHERE client_id = '8302'
AND appointment > NOW( );

+---------------------------------+
| Reminder                        |
+---------------------------------+
| Il tuo appuntamento è in marzo. | 
+---------------------------------+