Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Oracle SQL rounding method
I am using an Oracle 8i database and from what I understand, the round function defaults to using the symmetric arithmetric rounding (or round-half-up) method. I am trying to to use the round-to-even method (or unbiased rounding, convergent rounding, statistician's rounding, dutch rounding...- hnhranch2
- Post #3
- Forum: Oracle: All versions
-
Oracle SQL rounding method
How do I get Oracle SQL to use the bankers rounding method instead of the symmetric arithmetic rounding method? Or has anyone written a function to do this in Oracle? MS Visual Basic defaults to this method but Oracle does not.- hnhranch2
- Thread
- Replies: 8
- Forum: Oracle: All versions
