Re: Date substraction

From: Andrew Protasov <protasov_at_percombank.kiev.ua>
Date: 1998/02/05
Message-ID: <6bcbdi$978@post.percombank.kiev.ua>#1/1

Hi Vaughan,

It is quite obvious - add difference to any date without time part and then use to_char:

select to_char(trunc(sysdate)+(d1-d2),'HH24:MI:SS') from (select sysdate+1/2 d1,sysdate d2 from dual);

                             Andrew Protasov

Vaughan Mc Carthy wrote in message <6bc0hj$svq$1_at_hermes.is.co.za>...
>Hi there
>How do I sustract one date from another and get the answer in HH:MM:SS
>format ?? e.g. If I substract date from sysdate, I get a value. How do I
>covert THAT to HH:MM:SS ??
>
>Vaughan(vaughan_at_medscheme.co.za)
>
>
Received on Thu Feb 05 1998 - 00:00:00 CST