Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group