Previous Topic Next topic Print topic


TRUNCATE

ANSI DB2 SQL/DS XDB
      X

Truncates expr1 to the precision specified in int_expr. The format appears below:

TRUNCATE(expr, int_expr)

Can truncate to negative decimals. For example:

TRUNCATE(549.55,1) = 549.5
TRUNCATE(549.55,-1) = 540.00
TRUNCATE(549.55,-2) = 500
Previous Topic Next topic Print topic