Skip to Content
0
Former Member
Jun 29, 2009 at 10:05 PM

Group by Month, Group By Year

68 Views

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.