SQLite Forum

storing number with 2 decimal place
Login
Your immediate difficulty can be cured by [using printf(...)](https://sqlite.org/lang_corefunc.html#printf) to **display** the value stored in your database. See the link for details. Or, more precisely: Visit the linked web page and read the specified section.

In the longer term, you need to think about how 2.0 differs from 2.00, which is not a simple matter if you consider representation, manifestation, interpretation, rendering, and "reality" to be independent concepts. Think hard about that, do some study, and you should find these issues much easier to deal with.