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