On 15 Feb 2010, at 8:51am, [email protected] wrote: > sqlite> select round(40223+0.5); > 40224.0 > sqlite> select round(40224+0.5); > 40224.0 > sqlite> select round(40225+0.5); > 40226.0
Nice try. The rounding rule is that a .5 rounds to the nearest even number. This is so that rounding does not introduce its own statistical bias to a collection of results. For instance, rounding ten thousand random numbers then taking the average, should give you roughly the same result as taking the average of those numbers, then rounding. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
