On 29 Apr 2011, at 9:09pm, Jean-Marie CUAZ wrote: > Win XP + SQLite 3.7.4 > > SELECT round(8.875,2) -> 8.88 > SELECT round(16.875,2) -> 16.87 > SELECT round(32.875,2) -> 32.88 > SELECT round(64.875,2) -> 64.87
The documentation for SQLite does not mention what rounding algorithm is used: http://www.sqlite.org/lang_corefunc.html I suspect it's using banker's rounding. That's a reasonably good rounding method intended to round without disturbing the mean. If you think it shouldn't, what else, and why ? Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
