| Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 | 
 | 
| 
 | PDF · Mobi · ePub | 
The INTPART function calculates the integer part of a decimal number by truncating its decimal fraction.
INTEGER
INTPART(expression)
The decimal expression whose integer part is to be returned.
When expression has a value larger than is allowed for an INTEGER (a value between -2,147,483,647 and 2,147,483,647), INTPART returns an NA value.