Re: How to GROUP results BY month - Mailing list pgsql-sql

From Lennin Caro
Subject Re: How to GROUP results BY month
Date
Msg-id 936126.11927.qm@web59510.mail.ac4.yahoo.com
Whole thread Raw
In response to Re: How to GROUP results BY month  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-sql
i think this work

select id,count from table group by to_char(date,'MM')

--- On Wed, 7/16/08, A. Kretschmer <andreas.kretschmer@schollglas.com> wrote:

> From: A. Kretschmer <andreas.kretschmer@schollglas.com>
> Subject: Re: [SQL] How to GROUP results BY month
> To: pgsql-sql@postgresql.org
> Date: Wednesday, July 16, 2008, 5:39 AM
> am  Tue, dem 15.07.2008, um 18:15:07 -0700 mailte Mark
> Roberts folgendes:
> > 
> > On Tue, 2008-07-15 at 14:31 +0200, A. Kretschmer
> wrote:
> > > am  Tue, dem 15.07.2008, um 13:12:39 +0100 mailte
> Oliveiros Cristina folgendes:
> > > > Howdy, all,
> > > > 
> > > > I have a problem.
> > > > 
> > > > I have a table which one of the fields is of
> type date.
> > > > 
> > > > I need to obtain the totals of the other
> fields in a  by-month basis
> > > > IS there any easy way to do this using the
> GROUP BY or any other construct?
> > > 
> > > ... group by extract(month from date)
> > > 
> > > 
> > > Andreas
> > 
> > It's worth noting that extract(month from
> timestamp) returns a month_no, and thus will not be
> suitable for grouping queries that span years.
> 
> Right, but that wasn't the question...
> 
> 
> Andreas
> -- 
> Andreas Kretschmer
> Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr:
> -> Header)
> GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA  
> http://wwwkeys.de.pgp.net
> 
> -- 
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql

     



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_advisory_lock(bigint) vs. LOCK TABLE
Next
From: "Oliveiros Cristina"
Date:
Subject: Re: How to GROUP results BY month