Re: Floor Decimal Math
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 in
binary differently that 0.11 (bit-rounding errors).
W
>
> mysql> select (11.11-FLOOR(11.11))>=0.11;
> +----------------------------+
>
> | (11.11-FLOOR(11.11))>=0.11 |
>
> +----------------------------+
>
> | 0 |
>
> +----------------------------+
>
> Any help would be appreciated,
>
> Many thanks,
>
> Adam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx