-Pollo-
asked on
Using the Round function in Sybase 12.5
If I have the following table:
Table
---------
ID(integer) Cost(float)
2 1.1499999999999999
and then run the following update:
update Table
set Cost = round((Cost + 1),2)
where ID=2
the result is:
Table
---------
ID(integer) Cost(float)
2 2.1499999999999999
Why isn't Round rounding and what do I achieve the desired affect (where Cost is rounded to 2.15)?
Table
---------
ID(integer) Cost(float)
2 1.1499999999999999
and then run the following update:
update Table
set Cost = round((Cost + 1),2)
where ID=2
the result is:
Table
---------
ID(integer) Cost(float)
2 2.1499999999999999
Why isn't Round rounding and what do I achieve the desired affect (where Cost is rounded to 2.15)?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.