Problem printing difference in date

From: Forte Agent <1443131_at_usenetplanet.com>
Date: Mon, 20 May 2002 14:44:44 -0400
Message-ID: <0rfieukc26uep9pe4jfv0bso085ndauevr@4ax.com>

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. Received on Mon May 20 2002 - 13:44:44 CDT