Trunc

4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next

version 3


Trunc (number; places) Number

ParameterTypeDescription
numberNumberNumber to be truncated
placesNumberNumber of decimal places used for truncating
Function resultNumberNumber with its decimal part truncated to the
number of decimal places specified by Places

Description

Trunc returns number with its decimal part truncated to the number of decimal places specified by places. Trunc always truncates toward negative infinity.

If places is positive, number is truncated to places decimal places. If places is negative, number is truncated on the left of the decimal point.

Example

The following example illustrates how Trunc works with different arguments. Each line assigns a number to the vlResult variable. The comments describe the results:

   vlResult:= Trunc (216.897; 1)  ` vlResult gets 216.8 
   vlResult:= Trunc (216.897; –1)  ` vlResult gets 210 
   vlResult:= Trunc (–216.897; 1)  ` vlResult gets –216.9 
   vlResult:= Trunc (–216.897; –1)  ` vlResult gets –220

See Also

Round.


4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next