Someone

select cast(1.53 as signed integer);

it returns 2 where as the integer of 1.53 should be 1 ...

any help in converting a value to int ?