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): rounds decimal places up and down

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

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

ROUND(a,n)
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