Answers for "truncate an int in sql"

SQL
1

sql truncate number

-- Truncate number with 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 ...;
Posted by: Guest on May-10-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language