Thread: Math BUG??
View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 08:49 AM
Lee Peedin
 
Posts: n/a
Default Re: Math BUG??

On 21 Dec 2006 07:03:22 -0800, "kkmigas@gmail.com" <kkmigas@gmail.com>
wrote:

>Can some one plz explain this???
>
>SELECT ((200.45 * 1) * (10/100)),ROUND( (200.45 * 1 * (10/100)) ,2);
>
>Linux (Servidor Mysql 4)
>
>20.04 | 20.04
>
> Windows (Servidor Mysql 4)
>
>20.05 | 20.05
>
>Thanks



Here's my results of:
SELECT VERSION();
SELECT ((200.45 * 1) * (10/100)),ROUND( (200.45 * 1 * (10/100)) ,2)

Linux
5.0.24a
20.45000 | 20.05

Windows
5.0.24-community-nt
20.45000 | 20.05

Reply With Quote