homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Rounding calculation in mysql
how to round

 7:14 pm on Sep 18, 2005 (gmt 0)
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



 1:53 am on Sep 19, 2005 (gmt 0)

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.

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved