---

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