Adrian Sherwin, on Monday, November 4, 2019 03:41 AM, wrote... > > Hi, > > I would like to report the following as a bug in SQLITE: > > The SQLITE "round" function fails to round between 4.1 and 4.6% of numbers > correctly to x decimal places when held as x+1 decimal places. > > The simplest example I have found with x=1 is: > "select round(1.15,1)" > Result: "1.1" (should be 1.2)
I asked the same question before, but it is part of the SQLite FAQ [1]. Ihth. josé [1] https://www.sqlite.org/faq.html#q16 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users