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
