Re: [SQL] group by date_part

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: M(dot)Mazurek(at)poznan(dot)multinet(dot)pl
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] group by date_part
Date: 2000-02-21 01:05:45
Message-ID: 16609.951095145@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

M(dot)Mazurek(at)poznan(dot)multinet(dot)pl writes:
> select count (*) from stats group by date_part('dow',data::datetime_;

> I get everthing sortded just as I wanted to, but how can I ad another
> column to know which dow it is?

select date_part('dow',data::datetime), count(*) from stats
group by date_part('dow',data::datetime);

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message M.Mazurek 2000-02-21 02:07:33 Re: [SQL] group by date_part
Previous Message jdb371 2000-02-21 00:39:47 it wont let me delete