Answers for "sql convert float to number"

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

sql cast to float

SELECT CAST(25.65 AS int);

Posted by: Guest on August-17-2021

Code answers related to "sql convert float to number"