Returns the largest integer value less than or equal to the argument. The argument is an expression that returns a value of any built-in numeric data type.
Example:
Use the FLOOR function to truncate any digits to the right of the decimal point.
SELECT FLOOR(SALARY) FROM CORPDATA.EMPLOYEE