FLOOR

Syntax

floor::=

Text description of floor

Purpose

FLOOR returns largest integer equal to or less than n.

Examples

The following example returns the largest integer equal to or less than 15.7:

SELECT FLOOR(15.7) "Floor" FROM DUAL;

     Floor
----------
        15