On Monday, 4 November, 2019 02:16, Graham Holden <sql...@aldurslair.com> wrote:
>This is almost certainly because (according to >https://www.h-schmidt.net/FloatConverter/IEEE754.html) the number >"1.15" cannot be expressed exactly in floating-point; the nearest >expressible number being 1.14999997615814208984375, and presumably >it is the floating-point representation that is being rounded, not >the "string" representation. While that may indeed be the single-precision floating point representation of 1.15, the double precision floating point representation is: 1.149999999999999911182158 and the next representable double precision floating point number is 1.1500000000000001332267629 -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
