Re: grouping a mysql datetime col by month?

On Wed, 7 Aug 2002 13:29:02 +0100 "Dave Carrera" <dave@davecarrera.com> wrote: > This is a continuation from my last post a I was wondering after looking > > at my db if you can group by the month part of the datetime stamp I use > in my MySql db > > so the sql would probably look like this > > select * from table group by datetime[month] > > So that all month 08 is group and 09 and 10 and so on. > > I can't find a simple answer to this so I beg your guidance. > > Thank you in advance Did you look Adam's response to your last post ? that is exactly what you need. hth pa