FLOOR

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