Olaf Schmidt <[EMAIL PROTECTED]> wrote: > The integrated round-function works well so far, > especially because it does "bankers rounding". > Tough it seems to have a little bug, wich is probably simple to fix. > > Try... > select round(0.94, 1) -> gives 0.9, wich is correct > select round(0.96, 1) -> gives 1, wich is correct too > > but... > select round(0.95, 1) -> gives 0, wich is not correct of course > Regarding bankers rounding, wich rounds up in case of a > '5' at the appropriate position, the correct result should be 1. > > (tested with 3.3.17) >
http://www.sqlite.org/faq.html#q18 -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
