TRUNCATE

Restriction: This topic applies to Windows environments only.
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
Parent topic: Numeric Functions