FLOOR

The FLOOR function returns the largest INTEGER that is less than or equal to the input argument.

Syntax

FLOOR (argument) 

Remarks

The table lists the valid input argument data types and the resulting output data types.

Data Type of Argument	Output Type
BIGINT, DECIMAL, FLOAT, INTEGER, NUMERIC, REAL, SMALLINT, TINYINT	INTEGER
NULL	NULL