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

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