On 5/24/19, Hajo Bruns <[email protected]> wrote: > Hi, > the round function seems to round inconsistently: > > ivesselect round(5.485,2), round (3.555,2),round (3.255,2) > gives > 5,49 3,56 3,25 > > Last result should be 3.26
3.255 cannot be exactly represented as an IEEE754 double-precision binary floating point number. So the system has to use an approximation. The closest approximation is 3.25499999999999989341858963598497211933135986328125 and that value rounds to 3.25. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
