TRUNCATE(…num-expr…, …num-expr…)
TRUNCATE …num-expr…
num1, num2 -> largest(num1, num2)
Truncate the first operand to the nearest (from below) multiple of the second, or to the nearest integer if no second operand is provided (it is then equivalent to floor .
| expression | evaluates to |
|---|---|
| TRUNCATE(153.6, 10) | 150 |
| TRUNCATE 5.8 | 5 |
| TRUNCATE(-2.3) | -3 |