A good start at the long answer can be found in the archives of this list. http://sqlite.1065341.n5.nabble.com/Simple-Math-Question-td85140.html#a85157 also found at https://www.mail-archive.com/sqlite-users at mailinglists.sqlite.org/msg04587.html (web search sqlite "simple math question")
It has background, theory, and they show how the conversions of decimals to floating point and how they add works, using several examples. regards, Adam D. On Fri, Dec 11, 2015 at 9:55 AM, Richard Hipp <drh at sqlite.org> wrote: > On 12/11/15, Frank Millman <frank at chagford.com> wrote: >> >> Can anyone explain what is going on, and is there a way to avoid it? >> > > Short answer: https://www.sqlite.org/faq.html#q16 > > I don't have a longer answer readily at hand, but as questions about > floating point numbers come up a lot, probably I should write up a > tutorial. I'll try to get that done before the end of the year... > -- > D. Richard Hipp > drh at sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- -------------- VerifEye Technologies Inc. 151 Whitehall Dr. Unit 2 Markham, ON L3R 9T1
