Convert int to real in sqlite

Question

Split in sqlite returns an integer value

sqlite> select totalUsers/totalBids from (select (select count(*) from Bids) as totalBids , (select count(*) from Users) as totalUsers) A; 1 

Is it possible to come up with a result to get the real value of the separation result?

Answer 1

Just multiply one of the numbers by 1.0 :

 SELECT something*1.0/total FROM somewhere 

This will give you floating point division instead of integer division.

Answer 2

In Sqlite, dividing an integer by another integer will always round to the nearest integer.

Therefore, if you list your counter on a float:

 SELECT CAST(field1 AS FLOAT) / field2 

Answer 3

 select cast ( ( select 1 ) as real ); 

https://www.sqlite.org/lang_expr.html#castexpr

Answer 4

or if you want to update a column based on a text column:

 UPDATE table_with_fields SET real_field=cast(field_with_txt AS real)