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