Skip Headers

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

Part Number B10339-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

INTPART

The INTPART function calculates the integer part of a decimal number by truncating its decimal fraction.

Return Value

INTEGER

Syntax

INTPART(expression)

Arguments

expression

The decimal expression whose integer part is to be returned.

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

Example 15-19 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