ROUND

ROUND returns the number closest in value to the first argument, rounding away from zero. The second argument specifies the precision, with positive values indicating a position to the right of the decimal point, and negative values indicating a position to the left of the decimal point. All positions to the right of the specified position are zero in the result:

Integer ROUND( value integer, precision integer )

Decimal ROUND( value Decimal, precision integer )

Double ROUND( value Double, precision integer )

Example

The following code:

SELECT ROUND(123.4567, 2), ROUND(123.4567, -1)

returns:

123.46, 120

For decimal data types, the result’s precision and scale are (p + 1, s), where
(p, s) are the precision and scale of the operand.

Copyright Actuate Corporation 2012