473,320 Members | 1,839 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Round(45.923, -1)

Kindly explain the output of the function
ROUND(45.923, -1)
The answer is being shown as 50
Feb 11 '11 #1
4 4499
Rabbit
12,516 Expert Mod 8TB
You're rounding to the nearest 10 by passing in -1.
Feb 11 '11 #2
so if it is Round(42.365,-1) it will be rounded to 40 and not 50 right?
Feb 11 '11 #3
Rabbit
12,516 Expert Mod 8TB
Yes, but wouldn't it have been faster for you to run it and see the result rather than wait for someone to respond?
Feb 11 '11 #4
Hi Rabbit,
Thanks for your reply.
The problem is that, neither I have SQL nor ORACLE installed in my system @ my workplace. If I had that I would not have started this thread.
Feb 13 '11 #5

Sign in to post your reply or Sign up for a free account.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.