How to substract time from sysdate

[mike9]

Tarry,

I didnt realy get the goal of your statment because your result will always be -1 whatever sysdate and the unit of sysdate is.

sysdate+1/(1*60*60*24)-sysdate-2/(1*60*60*24))*(60*60*24)=

( (sysdate - sysdate) + (1-2) / (1*60*60*24)) * (60*60*24)=

           0          -   1   / (1*60*60*24)  * (60*60*24)= 

-1 * (60*60*24) / (60*60*24)=

-1 

to see the difference i would rather format the output with to_char(date_val,'DDMMYYYY HH24:MI:SS')

Cheers
Mike