MySQL group by Date, but output month name

Asked Sep 07 '16 at 10:50

Active Sep 07 '16 at 10:50

Viewed 47 times

I'm around 70% sure this is doable, I seem to remember I did something similar a few years ago, but have since forgotten how to do it (if I ever did).

Basically, I have a table in MySQL with an 'uploaded_date' field.

The format of the date is D/M/YYYY

I know how to group and order by the date, however I'd like to return the date as a month name. For example:

September:

Result
Result
Result

October:

Result
Result
Result

Etc..

Is there an easy way to do this in a MySQL query?

asked Sep 07 '16 at 10:50

Steviewevie

1

Are you looking for [`MonthName()`](https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_monthname) – Arulkumar Sep 07 '16 at 10:53
1

`GROUP BY MONTH(uploaded_date)` – Alive to die - Anant Sep 07 '16 at 10:54
1

Fix the date data type – Strawberry Sep 07 '16 at 11:18
You should do the final formatting of the results in the application. To generate the exact output you describe is possible in MySQL, but requires a more complicated query, than repeating the month name in every record. – Shadow Sep 07 '16 at 11:26
merely do the the group by. But have an additional wrapper for monthname at the end. So an extra outer loop. – Drew Sep 07 '16 at 12:10

MySQL group by Date, but output month name

0 Answers0