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