MySQL MONTHNAME() from numbers

by

You can use STR_TO_DATE() to convert the number to a date, and then back with MONTHNAME()

SELECT MONTHNAME(STR_TO_DATE(6, '%m'));

+---------------------------------+
| MONTHNAME(STR_TO_DATE(6, '%m')) |
+---------------------------------+
| June                            |
+---------------------------------+

Warning: This could be slow if done over a lot of rows.

More Related Contents:

  1. NOT LIKE not working with SHOW [duplicate]
  2. get first occurrence of last changed value of a column [closed]
  3. MySQL – Rows to Columns
  4. ROW_NUMBER() in MySQL
  5. How to define a custom ORDER BY order in mySQL
  6. How can I temporarily disable a foreign key constraint in MySQL?
  7. How to get the number of days of difference between two dates on MySQL?
  8. Creating a “Numbers Table” in MySQL
  9. MYSQL Select MAX Date inside a join statement
  10. Choosing a stand-alone full-text search server: Sphinx or SOLR? [closed]
  11. Determine which MySQL configuration file is being used
  12. MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
  13. Why do results from a SQL query not come back in the order I expect?
  14. MySQL combine two columns and add into a new column
  15. How does MySQL CASE work?
  16. How to save MySQL query output to excel or .txt file? [duplicate]
  17. MySQL: Set user variable from result of query
  18. Is there a naming convention for MySQL?
  19. How to integrate Apache Spark with MySQL for reading database tables as a spark dataframe? [closed]
  20. How to set a MySQL row to READ-ONLY?
  21. Finding number position in string
  22. Why does MySQL autoincrement increase on failed inserts?
  23. error code 1292 incorrect date value mysql
  24. How to search for rows containing a substring?
  25. Import CSV to Update only one column in table
  26. Error in MySQL library for Node.js
  27. MySQL – Meaning of “PRIMARY KEY”, “UNIQUE KEY” and “KEY” when used together while creating a table
  28. GRANT with database name wildcard in MySQL?
  29. Using SUM on FLOAT data
  30. Composite Primary Key performance drawback in MySQL

Leave a Comment