ROUND

Restriction: This topic applies to Windows environments only.

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