Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-02 |
|
|
View PDF |
The FLOOR function returns the largest whole number equal to or less than a specified number.
Return Value
NUMBER
Syntax
FLOOR(n)
Arguments
A whole number (NUMBER
data type) that you specify.
Examples
Example 15-23 Displaying the Largest Integer Equal to or Less Than a Number
The following statements show results returned by the FLOOR function.
The following SHOW FLOOR
statement produces the result that follows it.
SHOW FLOOR(15.7) 15
The following SHOW FLOOR
statement produces the result that follows it.
SHOW FLOOR(4) 4
The following SHOW FLOOR
statement produces the result that follows it.
SHOW FLOOR(-6.457) -7