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

1 vote230 views3 answers
Default password of mysql
SQL
0 vote246 views1 answer
Sql select most frequent value in column
SQL
0 vote262 views1 answer
Having all mysql
SQL
0 vote248 views1 answer
Space not removing from column in sql
SQL
0 vote238 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote254 views1 answer
Time data type in mysql
SQL
0 vote238 views1 answer
Groupby error in mysql
SQL
10 votes277 views4 answers
Sql server pagination
SQL
4 votes238 views1 answer
Id increment ms sql server
SQL
0 vote242 views1 answer
Mysql select statement after index
SQL