homepage Welcome to WebmasterWorld Guest from 184.73.40.21
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Rounding calculation in mysql
how to round
playadonna

10+ Year Member



 
Msg#: 39 posted 7:14 pm on Sep 18, 2005 (gmt 0)
im doing calculation in mysql how do your round up to 5.00
Ie:
if the answer is 123 want it to round up to 125

like using ceiling in excel

 

txbakers

WebmasterWorld Senior Member txbakers us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 39 posted 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:

[dev.mysql.com...]

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