SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rounding issue with numtodsinterval

j.siebenMar 8 2009 — edited Mar 8 2009

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 5 2009

Added on Mar 8 2009

3 comments

635 views