GROUP BY Month

[KashKurcura]

Hello:

Can someone please tell me if it is possible to do a query with a group by month? My date field is setup as YYYY-MM-DD.

SELECT * FROM Sales WHERE 1=1

Any help would be great!

[LordShryku]

Look up DATE_FORMAT in the MySQL manual. You can use that to sort by month