trunc

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

trunc ( numeric_expression1, numeric_expression2 )

Example

trunc ( 3.14159265, 3 )

Result

Returns 3.141.

Parent topic: DB2