Previous Topic Next topic Print topic


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
Previous Topic Next topic Print topic