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 |