| 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