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 exam
>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)