FLOOR

Syntax

Purpose

FLOOR returns largest integer equal to or less than n.

Example

SELECT FLOOR(15.7) "Floor" FROM DUAL;

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