I have a date column in my table and it looks like 2009/06/29. Is there a way I can GROUP BY MONTH and GROUP BY YEAR on this column?
Or do I have to create a YEAR column to GROUP BY YEAR, and a month column to GROUP BY MONTH?
Thanks.