Re: rounding behaviour

[David Garamond]

David Garamond wrote:

mysql> select 1/29;
+------+
| 0.03 |
+------+

mysql> select 100.0*1/29;
+------------+
|      3.448 |
+------------+

mysql> select 1/29*100.0;
+------------+
|       3.45 |
+------------+

sorry for the previous post, misleading problem statement. the exact problem for me is: mysql decides to automatically round numbers for me (which in some cases are undesirable, because i need the full precision floating point number from mysql and then format/process that number in my program).

using ROUND() seems to be the solution for this, but i still wonder whether mysql should decides number rounding automatically in the absence of ROUND().

--
dave

PS: mysql 3.23.49a-Max, linux on i386


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php