SQLite Forum

storing number with 2 decimal place
Login
What is wrong with storing 0.0 ? One can also get the two decimals when doing the query:

```
insert into t values(5.0/3);
sqlite> select * from t;
0.00
1.66666666666667
sqlite> select printf('%.2f',s) from t;
0.00
1.67
sqlite>
```