Output only the name of the month instead of the month number in MySQL

To display only the month number, use DATE_FORMAT() along with STR_TO_DATE(). Let us first create a table:

mysql> create table DemoTable1320
-> (
-> MonthName varchar(20)
-> );
Query OK, 0 rows affected (0.43 sec)

Example

Insert some records in the table using insert command −

mysql> insert into DemoTable1320 values('10/10/2010');
Query OK, 1 row affected (0.17 sec)
mysql> insert into DemoTable1320 values('11/12/2018');
Query OK, 1 row affected (0.15 sec)
mysql> insert into DemoTable1320 values('12/01/2019');
Query OK, 1 row affected (0.15 sec)

Display all records from the table using select statement −

mysql> select *from DemoTable1320;

Output

+------------+
| MonthName  |
+------------+
| 10/10/2010 |
| 11/12/2018 |
| 12/01/2019 |
+------------+
3 rows in set (0.00 sec)

Example

Here is the query to outputting the name of the month instead of the number −

mysql> select date_format(str_to_date(MonthName,'%d/%m/%Y'),'%M') from DemoTable1320;

Output

+-----------------------------------------------------+
| date_format(str_to_date(MonthName,'%d/%m/%Y'),'%M') |
+-----------------------------------------------------+
| October                                             |
| December                                            |
| January                                             |
+-----------------------------------------------------+
3 rows in set (0.00 sec)

AmitDiwan

Published on 04-Nov-2019 11:16:17

• Related Questions & Answers
• Getting month name instead of numeric month number in report in SAP
• Get Month Name from Month number in MySQL?
• Convert DATE timestamp to return only the month name in MySQL
• Mobile App Reviews of the Month
• Want to fetch only the month part from a date in MySQL
• How to get the first day of the current month in MySQL?
• How to get the first day of the previous month in MySQL?
• Python Pandas - Get the month number of the period from the PeriodIndex object
• Display month by name and number in Java
• Python Pandas - Get the total number of days of the month that the Period falls in
• Convert datetime to get month name in MySQL?
• MySQL query to update only month in date?
• C# Program to display the number of days in a month
• Get the last day of month in Java
• How to get the first day of next month in MySQL?