That "rule" is usually to try and get at the end the most accurate value, if your numbers are evenly distributed your final value will be closer to the "good one". So if your values will never have the rounding digit odd so you'll always be discarting half the smallest digit.. at the end of multiple calculations you generate bigger errors.
Sometimes one can say, you alternate when having middle values, once you go up, once down... Sometimes it's better to go up, for money calculations, etc This is getting off topic anyways Etienne Dibo Chen wrote: > > The rounding rule I learnt many years ago said, rounding in 1 if > previous digit is odd but discarding it if even. > > so 9.065 -> 9.06, 9.055 -> 9,06, ... > > Attila Soki wrote: > > > > hi, > > > > is this bug already in buglist, maybe in newer verisons of mysql is already > > corrected? > > if yes then please let me know please from what version. > > > > the probmlem: > > > > select round(9.065,2) > > +----------------+ > > | round(9.065,2) | > > +----------------+ > > | 9,06 | > > +----------------+ > > > > why not 9,07 ?? > > > > cheers, > > > > Attila Soki > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
