Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

Newcomers DBPro Corner / rounding

Author
Message
tubeular cube face
19
Years of Service
User Offline
Joined: 14th Jul 2005
Location:
Posted: 12th Feb 2006 18:21
Link
Is there a simple command for rounding?

Tubeularcubeface
Back to top
Profile PM
BatVink
Moderator
21
Years of Service
User Offline
Joined: 4th Apr 2003
Location: Gods own County, UK
Posted: 12th Feb 2006 19:33
Link
No! Do a forum search for rounding, you'll find many, many threads on the subject with 101 ways to achieve it.

Back to top
Profile PM Email
The Lone Programmer
21
Years of Service
User Offline
Joined: 29th Jan 2003
Location: California, USA
Posted: 13th Feb 2006 08:30
Link
I believe you would use the int(value) command. That command should round to the nearest whole number. If you want rounding to a decimal place you may have to create your own function.


The Lone Programmer

"Is The Juice Worth The Squeeze"
-The Girl Next Door
Back to top
Profile PM Website
BatVink
Moderator
21
Years of Service
User Offline
Joined: 4th Apr 2003
Location: Gods own County, UK
Posted: 13th Feb 2006 09:07
Link
INT doesn't round, it removes the decimals. 2.6 should round to 3, INT would make it 2.

Back to top
Profile PM Email
Daemon
18
Years of Service
User Offline
Joined: 16th Dec 2005
Location: Everywhere
Posted: 14th Feb 2006 00:04
Link
Incase you are still searching, the easiest way to round is to do.



Insanity is just a state of mind
Back to top
Profile PM Website
tubeular cube face
19
Years of Service
User Offline
Joined: 14th Jul 2005
Location:
Posted: 7th Mar 2006 18:19
Link
Thanks

Tubeularcubeface
Back to top
Profile PM
Back to top

Login to post a reply

Server time is: 2024-11-27 04:39:31
Your offset time is: 2024-11-27 04:39:31