Convert decimal number to INT SQL

sql sql-server casting decimal number-formatting

How about the obvious:

CAST(3562.45*100 as INTEGER)

sql sql-server casting decimal number-formatting

This works for me

SELECT FLOOR(55.5999)

sql sql-server casting decimal number-formatting

Or you can replace the decimal point.

select cast(replace('3562.45', '.','') as integer)

This way, it doesn't matter how many decimal places you have.

CodeHunter