Skip to Main Content
Forums

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!

Oracle rounding issue

960796Oct 4 2012 — edited Oct 5 2012
Pretty strange to see the below behaviour

select round(104.093749988719,4) from dual yields 104.0937, when mathematically it should be 104.0938

Which function should I be using to get 104.0938

Thanks,
SN
This post has been answered by unknown-7404 on Oct 4 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2012
Added on Oct 4 2012
13 comments
978 views