TRUNC:
Truncates a number to an integer
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])
Using the TRUNC function:
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). 
The TRUNC function truncates a number to an integer by removing the fractional part of the number.