Round

Summary

The Round function rounds up the numeric expression.

Syntax

Round(< numeric input>, <scale>, <mode>)

Return Type

Decimal

Details

The Round function uses HALF_DOWN rounding. The scale parameter represents the number of decimal places.

Examples

eval Round(2.276, 2);
2.28
eval Round(2.250, 1);
2.3
eval Round(1214.325*2, 1 , 'HALF_DOWN')/2;
1214.3
eval Round(1214.325*2, 1 , 'HALF_UP')/2;
1214.35
select Round(1976, -1) from Empty(rows=1);
1980
select Round(1976, -2) from Empty(rows=1);
2000

Related Functions