I am using SQLite and have the following query:

select round((10/3), 5) as example

And it displays the following result:

example|
-------+
3.0    |

I’ve tried several approaches such as casting to float, rounding, and multiplying the field times 1.0; but nothing seems to work.

Does anyone know why this happens? And how to resolve it…
Thank you in advance.