Re: [GENERAL] best way to calculate accumulating intervals timestamps

2007-04-02 Thread Richard Broersma Jr
> Management wants to know A+B over the course of multiple days and the start > and finish times can occur in arbitrary times. Any ideas for quickest way to > solve this problem? I know I can do it the dirty way in perl or whatever, > but I was hoping for a solution in SQL/PLSQL. Without using a

[GENERAL] best way to calculate accumulating intervals timestamps

2007-04-02 Thread Kenji Morishige
I'm hoping there is some way to do this without writing a function, but there may be no way around it. I have a table that contains two epoch based time stamps, 'start' and 'finish'. They are both timestamp values that are data wherehoused for resource utilization monitoring. Management wants t