Overview
Grammar | TRUNC(number, num_digits) | Truncates a number to an integer or a decimal by removing specified decimal places. |
Parameter 1 | number | Number to be truncated. |
Parameter 2 | num_digits | Number used to specify the truncation precision. |
Notes
The function supports two numerical parameters of which the second can be defaulted.
Example
| Formula | Result | Notes |
|---|---|---|
| TRUNC(8.9) | 8 | |
| TRUNC(-8.9) | -8 | |
| TRUNC(-8.98,1) | -8.9 | |
| TRUNC(PI()) | 3 |
