Tech
Forums
Jobs
Books
Events
Live
Interviews Prep
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
How to convert Decimal to Integer Format using sql query
bubai banerjee
Jan 20 2015 4:12 AM
889
Reply
I
want to round my Amount value from Decimal to Integer Format in sql query.
i
f 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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
How to insert data from one table to another table after cal
Can we add a column in a specific position in sql server???