Returns a number truncates to a number of decimal places, always towards zero.
Syntax:
TRUNC(number {, digits:number})
Truncates number to digits decimal places, always towards zero.
If supplied, digits must be an integer, either positive or negative (which applies truncation to the left of the decimal point).
If digits is omitted, zero is used.
Examples:
TRUNC(12345.678, 2)
returns 12345.67
, and
TRUNC(12345.678, -2)
returns the number 12300
.
Added in 1.36.