Date change in sql

Question

hi I have a date that is 2009-06-02 00: 00: 00.000, and I only want a monthly group.

how to change this ?!

Answer 1

You can group by month, but have data that spans more than one year. In this case, I would do:

group by Year(MyDate), Month(MyDate)

Answer 2

using

group by MONTH(record_date)

see this question for more information:

MySQL Query GROUP BY day / month / year

Answer 3

SELECT ... GROUP BY MONTH(datecolumn)