Re: Date subtraction showing Day:Hour:Min:Sec format
From: Brian Sachar <sachar_at_iserv.melpar.esys.com>
Date: Mon, 10 Jan 1994 21:08:07 GMT
Message-ID: <sachar.758236087_at_melpar>
Date: Mon, 10 Jan 1994 21:08:07 GMT
Message-ID: <sachar.758236087_at_melpar>
>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?
How about:
TRUNC(end_date - start_date)||':'||
TO_CHAR(TRUNC(SYSDATE) + end_date - start_date, 'HH24:MI:SS')?
Received on Mon Jan 10 1994 - 22:08:07 CET