FLOOR

Purpose

This function returns the largest whole number that is smaller or equal to n.

Syntax

floor::=

Floor

Usage notes

For more information on the CEIL() and ROUND() functions, see CEIL[ING] and ROUND (number).

Example

Copy

SELECT FLOOR(4.567) FLOOR;