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>


>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

Original text of this message