android - How to remove number after decimal in a table in sqlite database -


i have database in 1 column there floating number. want remove number after decimal in table in sqlite database. query should used remove number after decimal.

for round value: (2.34 = 2, 2.89 = 3)

select round(column) sample 

for floor value: (2.34 = 2, 2.89 = 2)

select cast(column int) sample 

is want ?


Comments