ROUND(a,n) 
ROUND(a,n) is an arithmetic function with the following result (for the expressions a and n that are numbers):
ROUND(a) –
round decimal places up and down
ROUND(a,n) – round up and down to the nth place on the right of the
decimal point
ROUND(a,-n) – round up and down to the nth place on the left of the
decimal point
|
Result of the ROUND(a,n) Function |
a>=0 |
TRUNC(a+0.5*10E-n,n) |
a<0 |
TRUNC(a-0.5*10E-n,n) |
n not specified |
Result as for n=0 |
n is not an integer |
The integer component of n is used and the result is as with a>=0 or a<0 |
a is floating point number |
Floating point number |
a is fixed point number |
Fixed point number |
a is the NULL value |
NULL value |
a is a special NULL value |
Special NULL value |