The FLOOR function returns the largest whole number equal to or less than a specified number.
NUMBER
FLOOR(n)
A whole number (NUMBER
data type) that you specify.
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