FLOOR

The FLOOR function returns the largest whole number equal to or less than a specified number.

Return Value

NUMBER

Syntax

FLOOR(n)

Arguments

n: A whole number (NUMBER data type) that you specify.

Examples

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
```