Hi,
You don't need to take it to 16 digits :
mysql 4 :
select 1/666;
+-------+
| 1/666 |
+-------+
| 0.00 |
+-------+
mysql 5.0.18:
select 1/666;
+--------+
| 1/666 |
+--------+
| 0.0015 |
+--------+
Actually, this is an entirely different case, it's a matter of where
MySQL decides how many digits to show by default. You can influence
that quite easily:
mysql> select 1.000000000/666;
+-----------------+
| 1.000000000/666 |
+-----------------+
| 0.00150150150 |
+-----------------+
1 row in set (0.00 sec)
Regards,
Jeremy
--
Jeremy Cole
MySQL Geek, Yahoo! Inc.
Desk: 408 349 5104
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
