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 as 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.
Results involving
DECFLOAT special values: For decimal floating-point values, the
special values are treated as follows:
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.