I don't get it:
mysql> select round(17.325,2);
+-----------------+
| round(17.325,2) |
+-----------------+
| 17.32 |
+-----------------+
1 row in set (0.00 sec)
mysql> select round(17.335,2);
+-----------------+
| round(17.335,2) |
+-----------------+
| 17.34 |
+-----------------+
1 row in set (0.00 sec)
mysql>
I'm trying to get that first number to round to 17.33, but it doesn't!!! Then if I make it 17.335, it DOES round up. What the hell is going on? Anyone know?
Mike
mysql> select round(17.325,2);
+-----------------+
| round(17.325,2) |
+-----------------+
| 17.32 |
+-----------------+
1 row in set (0.00 sec)
mysql> select round(17.335,2);
+-----------------+
| round(17.335,2) |
+-----------------+
| 17.34 |
+-----------------+
1 row in set (0.00 sec)
mysql>
I'm trying to get that first number to round to 17.33, but it doesn't!!! Then if I make it 17.335, it DOES round up. What the hell is going on? Anyone know?
Mike