On Dec 15, 2018, at 08.58, Jay Kreibich wrote: > > > On Dec 15, 2018, at 12:49 AM, Frank Millman <fr...@chagford.com> wrote: > > > > I know that floating point is not precise and not suitable for financial > > uses. Even so, I am curious about the following - > > [...] > > > > With the same version of sqlite3 and the same select statement, why does > > python return a different result from sqlite3.exe? > > Because the shell is altering the output to make it easier to read. Consider: > > $ sqlite3 > > SQLite version 3.16.0 2016-11-04 19:09:39 > > Enter ".help" for usage hints. > > Connected to a transient in-memory database. > > Use ".open FILENAME" to reopen on a persistent database. > sqlite> select 211496.25999999992; > 211496.26 >
That makes sense. Thanks, Jay _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users