How to remove digits after decimal in a table in SQLite database How to remove digits after decimal in a table in SQLite database sqlite sqlite

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 ?