SQL & PL/SQL

Hi,

I encounter a rounding issue with the numtodsinterval function when unsing it like this:

select numtodsinterval(to_date('2009.03.09T11:30:00', 'YYYY.MM.DD"T"HH24:MI:SS') - to_date('2009.03.08T09:30:00', 'YYYY.MM.DD"T"HH24:MI:SS'), 'DAY') interval
from dual;

INTERVAL
-----------
1 1:59:59.999999999

1 rows selected

I tried to avoid this outcome, but with no luck. Is anybody aware of a solution for this issue?

Thanks in advance,

Jürgen