Convert decimal number to INT SQL

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.

This works for me

SELECT FLOOR(55.5999)

How about the obvious:

CAST(3562.45*100 as INTEGER)

Related