Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] group by date_part - Mailing list pgsql-sql

From M.Mazurek@poznan.multinet.pl
Subject Re: [SQL] group by date_part
Date
Msg-id Pine.BSF.4.21.0002210206400.72356-100000@arka.poznan.mtl.pl
Whole thread Raw
In response to Re: [SQL] group by date_part  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
On Sun, 20 Feb 2000, Tom Lane wrote:
> select date_part('dow',data::datetime), count(*) from stats
>     group by date_part('dow',data::datetime);

thx, i think i got the idea:)

mazek

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] group by date_part
Next
From: Rodrigo Rezende
Date:
Subject: Re: [SQL] Select & Tables X Select & Views