SQLite Forum

storing number with 2 decimal place in Sqlite3 with python3
Floating Point does not store an arbitrary number of digits after the decimal point.

The "standard" way to cause a floating point number to be "displayed" with exactly 2 decimal digits, even if the trailing one is a zero, has been since at least the middle of the twentieth century, to use an output mask that looks like this:  '%12.02f' which causes the number to be formatted (right justified) into a field 12 characters wide with two digits EXACTLY (even if they are 0) after the decimal point.

In other words, this is a USER INPUT AND DISPLAY PROBLEM and has nothing whatsoever to do with SQLite3, which is merely a storage system.