ROUND

Returns the rounded value of a numeric expression.

Syntax

ROUND ( num_expression
[ , rounding_factor]);

Notes

num_expression must be numeric or must be convertible to numeric.

num_expression must be one of these supported data types:

INTEGER

TINYINT

SMALLINT

NUMBER

FLOAT

DOUBLE PRECISION

If the data type of num_expression is not a supported type, ROUND returns an error message.

The num_expression is rounded to the next higher digit when:

The digit before a negative rounding_factor is 5 or greater

The digit after a positive rounding_factor is 5 or greater

The num_expression is rounded to the next lower digit when:

The digit before a negative rounding_factor is 4 or less

The digit after a positive rounding_factor is 4 or less

rounding_factor is an integer between -32 and +32 inclusive, and indicates the digit position to which you want to round num_expression. The following figure illustrates how the digit positions are numbered. In the figure below, the num_expression is 2953861.8320.

Figure 1. ROUND digit positions

If you do not specify a rounding_factor, the function rounds num_expression to digit 0 (the ones place).

To round to the right of the decimal point, specify a positive rounding_factor.

To round to the left of the decimal, specify a negative rounding_factor.

Example

This example illustrates four calls to the ROUND function:

-- rounding_factor 2 returns 2953861.83
ROUND ( 2953861.8320, 2 )
-- rounding_factor -2 returns 2953900.00
ROUND ( 2953861.8320, -2 )
-- rounding_factor 0 returns 2953862.00
ROUND ( 2953861.8320, 0 )
-- No rounding_factor argument also returns 2953862.00
ROUND ( 2953861.8320 )

In each case the num_expression is 2953861.8320. In the first call the rounding_factor is 2, in the second call the rounding_factor is -2, in the third call therounding_factor is 0, and in the fourth call no rounding_factor is specified.

Compatibility

Progress extension