Re: [GENERAL] tricky date manipulations?

[Frank Bax]

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