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.
OLADM1718Large 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.
OLADM1719Example 7-130 Calculating the Integer Part of a Decimal Number
The following example shows the integer part of the number 3.14
. The statement
show intpart(3.14)
produces the following result.
3