On 5/24/19, Thomas Kurz <[email protected]> wrote: > ... decimal math ....
Therein lies your misunderstanding. SQLite does not do decimal math. It does binary math, and in particular IEEE754 double-precision binary math. And in that numeric system, 3.255 and 3.2549999999999998 are the exact same number, and hence always round the same. I do not know what the underlying representation for floating point numbers is in Excel, but as your experiment shows, it is probably not IEEE754 double-precision binary. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
