On May 16, 2008, at 2:42 AM, Adam de Zoete wrote:
Thanks for your responses, i thought it was a float problem so i was
trying to CAST as a DECIMAL to fix it. It turns out (and the manual
does not document this) that casting as decimals doesn't actually
work in mysql 4.1.20. ROUND() is
Thanks for your responses, i thought it was a float problem so i was
trying to CAST as a DECIMAL to fix it. It turns out (and the manual does
not document this) that casting as decimals doesn't actually work in
mysql 4.1.20. ROUND() is needed instead.
mysql select
On Thursday 15 May 2008 13:24:10 Adam de Zoete wrote:
Hi,
I'm running mysql 4.1.20 (Mac OS 10.4.11) and wondering why this ain't
returning the right answer? Maybe i'm missing something or am i doing
something wrong?
Perhaps it is performing FLOAT and not DECIMAL math. 11.11 is represented
Don't feel bad, many an experience programmer has been bitten by this.
The problem is that many decimal fractions do not have exact representations
as binary fractions. .01 is an example of this.
I'm not sure how MySQL does arithmetic internally, but (11.11 - 11) is just
a hair under .11:
mysql
-Original Message-
From: Adam de Zoete [mailto:[EMAIL PROTECTED] On Behalf Of
Adam de Zoete
Sent: Thursday, May 15, 2008 6:24 AM
To: mysql@lists.mysql.com
Subject: Floor Decimal Math
Hi,
I'm running mysql 4.1.20 (Mac OS 10.4.11) and wondering why this ain't
returning the right