Sql remove decimal places

-- use cast
UPDATE my_table
SET my_column = CAST(my_column AS INT)
WHERE ...;
-- or convert
UPDATE my_table
SET my_column = CONVERT(INT, my_column)
WHERE ...;

Source: stackoverflow.com

Similar codes

2 votes113 views1 answer
Sql select in list
SQL
2 votes220 views5 answers
Install postgresql 10 centos 7
SQL
0 vote165 views1 answer
Mysql default timestamp value to be current timestamp
SQL
0 vote173 views1 answer
Setval in postgres
SQL
1 vote199 views2 answers
Changes not showing on website server odoo
SQL
0 vote174 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote179 views1 answer
Copy data from one postgres container to another
SQL
0 vote165 views1 answer
Concatenate columns in table
SQL
1 vote159 views1 answer
How to use a trigger to validate input data
SQL
2 votes172 views1 answer
Enum in SQL Server
SQL