truncate

Returns "numeric_expression1" truncated to "numeric_expression2" places to the right of the decimal point. If "numeric_expression2" is negative, "numeric_expression1" is truncated to the absolute value of "numeric_expression2" places to the left of the decimal point.

Syntax

truncate ( numeric_expression1, numeric_expression2 )

Example

truncate ( 3141.59265, -3 )

Result

Returns 3.

Parent topic: DB2