FLOOR Function [Numeric]

Returns the floor of (largest integer not greater than) a number.

Syntax

FLOOR ( numeric-expression )

Parameters
Parameter	Description
numeric-expression	The number, usually a float.

DOUBLE

The following statement returns the value 123.00:

SELECT FLOOR ( 123 ) FROM iq_dummy

The following statement returns the value 123:

SELECT FLOOR ( 123.45 ) FROM iq_dummy

The following statement returns the value -124.00.

SELECT FLOOR ( -123.45 ) FROM iq_dummy