Re: Problem printing difference in date

you have to write a function to xform this output.

On Mon, 20 May 2002 14:44:44 -0400, Forte Agent <1443131_at_usenetplanet.com> wrote:

>
>This is gotta be simple but I do not know how. . . I am simply tring
>to calculate difference in time and print it, as shown below:
>
>
>SQL> alter session set nls_date_format='MM/DD/YYYY HH24:MI:SS';
>
>Session altered.
>
>SQL> select to_date('5/2/2002 10:00:00') - to_date('5/1/2002 1:00:00')
>from dual;
>
>TO_DATE('5/2/200210:00:00')-TO_DATE('5/1/20021:00:00')
>------------------------------------------------------
> 1.375
>
>SQL>
>
>
>
>Instead of "1.375", I would like to get "33:00" (thirty three hours of
>difference) as output (or "0/1/0000 9:00" = One day and nine hours).
>How to do it? I know I can do something like this:
>
>
>
>SQL> select trunc(sysdate) + 1.375 from dual;
>
>TRUNC(SYSDATE)+1.37
>-------------------
>05/21/2002 09:00:00
>
>
>
>But again, I just want "33:00" as output, not with some bogus date
>along with it. Thank you in advance.
>
>
>
>

.......
We use Oracle 8.1.7.3 on Solaris 2.7 boxes remove NSPAM to email Received on Mon May 20 2002 - 15:16:18 CDT