TRUNC

4D - Documentation   Français   English   German   Japanese   4D SQL Reference, Table of Contents   4D SQL Reference, Index   Back   Previous   Next

version 11


TRUNC (arithmetic_expression[, arithmetic_expression])

Description

The TRUNC function returns the first arithmetic_expression truncated to "x" places to the right of the decimal point, where "x" is the second optional arithmetic_expression. If this second arithmetic_expression is not passed, the arithmetic_expression is simply truncated by removing any decimal places.

Example

This function truncates the number passed to 1 place after the decimal point:

   TRUNC(2.42 , 1)
       `returns 2.40

See Also

ROUND, TRUNCATE.


4D - Documentation   Français   English   German   Japanese   4D SQL Reference, Table of Contents   4D SQL Reference, Index   Back   Previous   Next