The function TRUNC takes a a Number and truncates it to a specified number of decimal places.
This function takes two Numbers as input: the first designates the number to be truncated, and the second specifies how many decimal places will remain after truncation. It outputs a single Number: the first number, with all decimal places past the given point removed without rounding.
TRUNC(base_number, digits) -> trunc_number
- base_number (type: Number)
- The number to be truncated.
- digits (type: Number)
- The number of decimal places that will remain after truncation.
- trunc_number (type: Number)
- The base number, truncated to the specified number of decimal places.
TRUNC(1.1234567890, 8) -> 1.12345678
The following example takes the number 1.12 and attempts to truncate it so that everything past the eight decimal place is dropped. 1.12 did not have that level of precision to begin with, and so TRUNC outputs the base number unmodified:
TRUNC(1.12, 8) -> 1.12