Link to home
Start Free TrialLog in
Avatar of -Pollo-
-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)?

       

ASKER CERTIFIED SOLUTION
Avatar of TadHawkins
TadHawkins

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial