On Fri, 24 May 2019 13:10:49 +0000 Jose Isaias Cabrera <jic...@outlook.com> wrote:
> >Consider these two queries: > > > > SELECT round(3.255,2); > > SELECT round(3.2549999999999998,2); > > > >Do you expect them to give different answers? > > 3.26 > 3.25 sqlite> SELECT cast(100 * (0.005 + 3.2549999999999998) as ...> integer)/100.0; 3.26 --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
