| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Pubcon Platinum Sponsor 2014|
|Rounding calculation in mysql|
how to round
|im doing calculation in mysql how do your round up to 5.00|
if the answer is 123 want it to round up to 125
like using ceiling in excel
I'm not sure you can round 123 up to 125 with a command, but the math functions of mySQL can be found here:
There is a CEIL command but it rounds up to the integer, not to within an integer.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved