Description:
Odd numbers round properly at the half (3.5) but even numbers don't (4.5).
How-To-Repeat:
mysql select round(15.5);
+-+
| round(15.5) |
+-+
| 16 |
+-+
1 row in set (0.01 sec)
mysql select round(16.5);
+-+
| round(16.5) |
Hi,
Odd numbers round properly at the half (3.5) but even numbers
don't (4.5).
This sounds like you're misunderstanding an intentional feature. A lot of
applications or system libraries do this to avoid giving 'incorrect' figures
when summing large amounts of rounded numbers.
Here's an