George Law wrote:
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 |
+--------+
That has nothing to do with the precision of the calculation. It is due
to the assumptions MySQL makes about how many digits to display. Try
select 1.00/666 and it will give the 0.0015. Add more zeros, and it
displays more significant digits.
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want &
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http://thewishzone.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
