The FLOOR function returns the largest integer value less than or equal to expression.
The result of the function has the same data type and length attribute of the argument except that the scale is 0 if the argument is a decimal number. For example, an argument with a data type of DECIMAL(5,5) will result in DECIMAL(5,0).
If the argument can be null, the result can be null; if the argument is null, the result is the null value.
SELECT FLOOR(SALARY) FROM EMPLOYEE
SELECT FLOOR( 3.5), FLOOR( 3.1), FLOOR(-3.1), FLOOR(-3.5), FROM SYSIBM.SYSDUMMY1This example returns:
3. 3. -4. -4.respectively.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.