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

0 vote107 views1 answer
Mysql query single row
SQL
0 vote97 views1 answer
Get all employee of salary if more than in sql
SQL
1 vote131 views1 answer
Sql server loop over query
SQL
0 vote103 views1 answer
Set open file limit mac catalina mysql
SQL
0 vote105 views1 answer
Sql select by content lenght
SQL
0 vote112 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote97 views1 answer
Take sql dump in to file
SQL
0 vote95 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
7 votes99 views1 answer
Postgres base size
SQL
0 vote104 views1 answer
How to convert DateTime to VarChar SQL
SQL