Round funcion
I want a rounding function that does the following:
column result
6.22 6.2
6.27 6.3
Any idea?

Hi Amin,
Did you try the TRUNC function to truncate the decimals?

Hi Amin,
I think what you really want is a floor or the rounddown functions. Both round a number down, the second argument is the number of digits after the decimal.
There's also the ceiling and the roundup function. similar to the above functions.
If you want to just have a normal round (return the nearest integer) there's the ROUND. This function however doesn't allow you to choose the number of places after the decimal point.
Please sign in to leave a comment.
Comments
6 comments