sql remove decimal places

Solutions on MaxInterview for sql remove decimal places by the best coders in the world

Search
showing results for - "sql remove decimal places"
Carey
14 Jul 2020
1-- use cast
2UPDATE my_table
3SET my_column = CAST(my_column AS INT)
4WHERE ...;
5-- or convert
6UPDATE my_table
7SET my_column = CONVERT(INT, my_column)
8WHERE ...;
source
similar questions
sql remove last 2 digitsql remove spacessql script to remove default from columnsql remove leading spacesremove all spaces from string sqlsql delete where x or y or zsql update table remove spacessql convert to integer from decimalremove time from date sqlsql decimal to 2 places2 decimal places sql sql trim all spacessql server decimalsql remove characters from string rightsql format decimal numbersql remove non numeric charactersfunction to remove special characters in sqlspace not removing from column in sqlsql strip non alphanumeric characterstrim leading zeros in sqlremove spaces sql serverremove spaces sql 2008sql server remove 0 from leftsql decimal 2818 0 29sql limit decimal places
queries leading to this page
remove 00 decimal sqlremove decimals in sql server functionremove decimal in sqlremove decimal places in sqlhow to remove decimal in sql queryremove decimal values in sql serverhow to remove digits after decimal in sql serverremove decimals sql sql server remove decimals from varsql 2016 drop decimal placestrim decimal places in sqlremove decimal places from sum in sqlhow to remove decimals in sqlhow we remove decimal from queryremove number after decimal in sqlremove numbers after decimal in sqlsql remove decimal placeseliminate decimals in sqlsql remove decimal places