The TRUNC function truncates a number to an integer by removing the fractional part of the number.

TRUNC takes 1 required argument and 1 optional argument:

Syntax: TRUNC(number, [num_digits])

#1)
Using the TRUNC function:
#2)
The arguments for the TRUNC function are:
Argument Required? Description
number Required The number you want to truncate.
num_digits Optional A number specifying the precision of the truncation. The default value for num_digits is 0 (zero).

Summary

The TRUNC function truncates a number to an integer by removing the fractional part of the number.
comments powered by Disqus