ANSI | DB2 | SQL/DS | XDB |
---|---|---|---|
X |
Rounds expr1 to the precision specified in int_expr. The format appears below:
ROUND(expr1,int_expr)
Can also round to negative numbers. For example:
ROUND(549.55,1) = 549.6 ROUND(549.55,-1) = 550.00 ROUND(549.55,-2) = 600.00