Group by month of datetime

Question

Can I group by month in a MySQL DATETIME field or do I have to create separate fields with just the month and the year?

possible duplicate of [MySQL Query GROUP BY day / month / year](http://stackoverflow.com/questions/508791/mysql-query-group-by-day-month-year) — AdamMc331, Jun 29 '15 at 19:07

score 0 · Accepted Answer · answered Jun 29 '15 at 19:02

0

You can like this

select month(datetime_field)
from your_table
group by month(datetime_field)

answered Jun 29 '15 at 19:02

juergen d

1 Answers1