How to remove digits after decimal in a table in SQLite database
For round value: (2.34 = 2, 2.89 = 3)
SELECT round(column) FROM sample
For Floor value: (2.34 = 2, 2.89 = 2)
SELECT cast(column as int) FROM sample
Is this what you want ?
For round value: (2.34 = 2, 2.89 = 3)
SELECT round(column) FROM sample
For Floor value: (2.34 = 2, 2.89 = 2)
SELECT cast(column as int) FROM sample
Is this what you want ?