TRUNC
Created: September 05, 2015 | Updated: August 13, 2021
| Applies to versions: 15.1, 16.0, 16.1, 17.0, 17.1, 18.0, 18.1, 19.0, 19.1, 20.0, 20.1 and 20.2
Now reading version 19.0. For the latest, read: TRUNC for version 21
Parent page: System Query Functions - Arithmetic Functions
Summary
Returns an integral number, whose value depends upon the nature of the parameter's numeric value:
- If that numeric value is positive but is not an exact integer, the number returned is the largest integer that is smaller in value than the parameter's numeric value.
- If that numeric value is negative but is not an exact integer, the number returned is the smallest integer that is larger in value than the parameter's numeric value.
- If that numeric value is an exact integer, the number returned has exactly the same value.
Syntax
TRUNC(X : Number / Numeric_String) : Number
Example Usage
TRUNC(5.0)
Returns 5.
TRUNC(5.33)
Returns 5.
TRUNC(-5.0)
Returns -5.
TRUNC(-5.33)
Returns -5.
Tips
- This is an alias for the INT arithmetic function.
