Explanation
With TRUNC, no rounding takes place.
TheTRUNC functionsimply slices off the decimal part of the number with default configs.
What about INT or ROUND?
You might wonder if you’re able to useINT function, or theROUND functioninstead.
However, for negative numbers, the rounding that INT does is a bit strange.
This is because INT rounds negative numbers down away from zero, no matter what the decimal value.
See the last 2 examples in the screen above for an example.
As you would expect, the ROUND function rounds numbers down.
As above, TRUNC is a safer option if you want the original integer portion of a number.
For example, TRUNC(4.9) will return 4, and TRUNC(-3.5) will return -3.
The TRUNC function does no rounding, it simply truncates as specified.
Note that negative numbers becomemore negative.
For example, while INT(10.8) returns 10, INT(-10.8) returns -11.
