ROUND(a,n)

Use

ROUND(a,n) is an arithmetic function with the following result (for the expressions a and n that are numbers):

ROUND(a): rounds decimal places up and down

ROUND(a,n): rounds up and down to the n th place on the right of the decimal point

ROUND(a,-n): rounds up and down to the n th place on the left of the decimal point

a, n	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 a floating point number	Floating point number
a is a fixed point number	Fixed point number
a is a NULL value	NULL value
a is a special NULL value	Special NULL value