Show TOC

ROUND(a,n)Locate this document in the navigation structure

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