sql - SQLite format number with 2 decimal places always

Question

I have some tables in a SQLite database that contains FLOAT column type, now i want to retrieve the value with a Query and format the float field always with 2 decimal places, so far i have written i query like this one :

SELECT ROUND(floatField,2) AD field FROM table

this return a resultset like the the following :

3.56
----
2.4
----
4.78
----
3

I want to format the result always with two decimal places, so :

3.56
----
2.40
----
4.78
----
3.00

Is it possible to format always with 2 decimal places directly from the SQL Query ? How can it be done in SQLite ?

Thanks.

question from:https://stackoverflow.com/questions/9149063/sqlite-format-number-with-2-decimal-places-always

Answer 1

You can use printf as:

SELECT printf("%.2f", floatField) AS field FROM table;

for example:

sqlite> SELECT printf("%.2f", floatField) AS field FROM mytable;
3.56
2.40
4.78
3.00
sqlite>