Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number B1033902 


View PDF 
The INTPART function calculates the integer part of a decimal number by truncating its decimal fraction.
Return Value
INTEGER
Syntax
INTPART(expression)
Arguments
The decimal expression whose integer part is to be returned.
Notes
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.
Examples