Postgres Pro
Downloads
Home   >   mailing lists

Re: tricky date manipulations? - Mailing list pgsql-general

From Frank Bax
Subject Re: tricky date manipulations?
Date
Msg-id 3.0.6.32.20000406212919.0149c100@execulink.com
Whole thread Raw
In response to tricky date manipulations?  (Alfred Perlstein <bright@wintelcom.net>)
List pgsql-general
Tree view 
At 05:35 PM 4/06/00 -0700, you wrote:
>select from a table several records and group by a date column.

just cast your datetime or timestamp (hour) field into a date...

select hour::date, sum(whatever) from table group by hour::date;

Frank

pgsql-general by date:

Previous
From: Alfred Perlstein
Date:
Subject: tricky date manipulations?
Next
From: Guillaume Perréal
Date:
Subject: Splitting one big table into smaller ones