Re: Date subtraction showing Day: Hour:Min:Sec format

In article <CJ4npv.13tt_at_empros.com>, btreuman_at_empros.com (Bob Treumann) writes:
|>
|>We need to do date subtraction to know how much time elapsed between
|>an event start and end time. We need to display it in days:hour:min:secs
|>Has anyone done this? Can you show me a script, or a PL*SQL procedure
|>to do it?
|>

This will print out the elapsed time between start_date and end_date as hh:mm:ss. For differences greater than 1 day, hours will be over 24 - you can play around with the first part to display days:hours if you prefer.

select
ltrim(to_char(trunc((end_date - start_date)*24),'09'))||':'|| ltrim(to_char((end_date - start_date)*1440 -   trunc((end_date - start_date)*24)*60,'09'))||':'|| ltrim(to_char((end_date - start_date)*86400 -   trunc((end_date - start_date)*1440)*60,'09')) from ...