Re: [PHP] ROUND inconsistency

2001-04-13 Thread Philip Hallstrom
In article <9b6c4v$m41$[EMAIL PROTECTED]> you write: >Correction, MySQL is not returning floor, since it returns 2 for round(1.5). - I >didn't see it. >MySQL should not return 2 for round(2.5), but it should return 3. I think it's >MySQL bug. > >How about ask in MySQL mailing list? I don't think

Re: [PHP] ROUND inconsistency

2001-04-13 Thread Yasuo Ohgaki
Correction, MySQL is not returning floor, since it returns 2 for round(1.5). - I didn't see it. MySQL should not return 2 for round(2.5), but it should return 3. I think it's MySQL bug. How about ask in MySQL mailing list? -- Yasuo Ohgaki ""Yasuo Ohgaki"" <[EMAIL PROTECTED]> wrote in message 9

Re: [PHP] ROUND inconsistency

2001-04-12 Thread Yasuo Ohgaki
MySQL is returning floor. (I'm not a MySQL heavy user, though :) PHP's result is correct for its function name, I think. If MySQL returns floor for round(), how about use floor() in PHP? Regards, -- Yasuo Ohgaki "Lee Howard" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL P

[PHP] ROUND inconsistency

2001-04-12 Thread Lee Howard
Using MySQL 3.23.32 on RedHat Linux 7.0... MySQL's ROUND function rounds 5 up when the preceding digit is odd and down when the preceding digit is even. mysql> select round(1.5); ++ | round(1.5) | ++ | 2 | ++ 1 row in set (0.00 sec) mysql> select rou