How to convert Decimal to Integer Format using sql query

Jan 20 2015 4:12 AM
I want to round my Amount value from Decimal to Integer Format in sql query.
if amount 65.33 then amount=65
if amount 65.53 then amount=66
i tried with round function. but not getting expected result.
I am a fresher.please help.Thanks in advance


Answers (2)