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/[EMAIL PROTECTED]
