Convert decimal number to INT SQL

Question

I want to convert the decimal number 3562.45 to 356245, either as an int or a varchar. I am using cast(3562.45 as int), but it only returns 3562. How do I do it?

Answer 1

How about the obvious:

CAST(3562.45*100 as INTEGER)

Answer 2

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.

Answer 3

This works for me

SELECT FLOOR(55.5999)