RE: Broken 'even number' rounding function

2001-09-18 Thread Basil Hussain
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

Broken 'even number' rounding function

2001-09-18 Thread User Aaron
>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)