| Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-05 |
|
|
View PDF |
The INTPART function calculates the integer part of a decimal number by truncating its decimal fraction.
Return Value
INTEGER
Syntax
INTPART(expression)
Parameters
The decimal expression whose integer part is to be returned.
Usage Notes
Large Values
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