Re: [SQL] group by date_part

From: M(dot)Mazurek(at)poznan(dot)multinet(dot)pl
To:
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] group by date_part
Date: 2000-02-21 02:07:33
Message-ID: Pine.BSF.4.21.0002210206400.72356-100000@arka.poznan.mtl.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rodrigo Rezende 2000-02-21 12:42:59 Re: [SQL] Select & Tables X Select & Views
Previous Message Tom Lane 2000-02-21 01:05:45 Re: [SQL] group by date_part