Re: Summary the data according to the time

Hi,

Try something like:

select to_char(24*6*trunc(timestamp/24/6),'YYYYMMDD HH24:MI'),

       sum(file_size)
from your_table
where <conditions>
group by to_char(24*6*trunc(timestamp/24/6),'YYYYMMDD HH24:MI');

where <timestamp> is your date/time column.

Cheers,
Jesper

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 03-09-99, 20:20:51, lily99_at_my-deja.com wrote regarding Summary the =

data according to the time:

> Hi,
> I have a log table which has file_size and date/time
> fields. I want to summary file_size based on every ten
> minutes. I read some Oracle books, but still cannot figure
> out how I can do this. Can someone help me with this issue?
> Thanks you very very much.

> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Sep 03 1999 - 13:41:54 CDT