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? I've tried manipulating ceil, floor, round and truncate and I can't seam to find an easy way to do this. I read in the manual that this behavior depends on the C library implementation, but how do you change it? To me, this is not normal behavior. Can anyone help? Thanks in advance... Best Regards, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]