Floor Decimal Math
- Date: Thu, 15 May 2008 12:24:10 +0100
- From: Adam de Zoete <lists@xxxxxxxxxxxxx>
- 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 answer? Maybe i'm missing something or am i doing
something wrong?
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