Actually, no, it rounds to .01233. > -----Original Message----- > From: Andrew Kuebler [mailto:[EMAIL PROTECTED]
> Can anyone explain why: > > SELECT ROUND(.012345, 5) > -> .01234 > > Why doesn't mysql round the 5 up to .01235? How do I get it > to round up? Oftentimes standard practice is to round up if the digit before the 5 is odd, and round down if it's even. (This averages out the bias you otherwise get with 5/4 rounding.) To see if this is what you're seeing, try rounding 0.012335 to 5 places...I bet it'll round up to 0.01234. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]