Answers for "sql convert float to 2 decimal places"

sql decimal to 2 places

CAST(MyNumber AS NUMERIC(18,2))

Posted by: Guest on March-22-2021

convert float to int sql

Better to use CAST INT/CEILING/FLOOR:

SELECT CEILING(1235.53)
SELECT FLOOR(1235.53)
SELECT CAST(1235.53 AS INT)

Posted by: Guest on March-03-2021

Code answers related to "sql convert float to 2 decimal places"