DML functions: Truncate

There is only one available Truncate function:

truncate Comment

Description

truncate truncates Real numbers to the number of decimal places that you specify.

Syntax

truncate(real_number_expression, decimal_places)

Return

Real number

Parameters

real_number_expression:

Enter an expression that returns a Real number

decimal_places

Enter an Integer that indicates the number of decimal places for the return value.

Examples

truncate(354.8526, 2) returns 354.85.

Related Links