FLOOR

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

Return Value

NUMBER

Syntax

FLOOR(n)

Parameters

n

A number.

Examples

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