Re: Problem printing difference in date

On Mon, 20 May 2002 21:05:53 +0200, Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:

>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.
>>
>>
>>
>
>select 24 * (to_date('5/2/2002 10:00:00') - to_date('5/1/2002
>1:00:00')) -- as the unit of date variable is a day and a day has 24
>hours
>from dual;
>
>What did you drink before posting this question?

Nothing but SlimFast. What else? (Probably is shrinking my brain along with my weight. Dang)

>
>Hth
>
>
>Sybrand Bakker, Senior Oracle DBA
>
>To reply remove -verwijderdit from my e-mail address
Received on Mon May 20 2002 - 22:50:04 CDT