SQL Reference

FLOOR

>>-FLOOR--(--expression--)-------------------------------------><
 

The schema is SYSFUN.

Returns the largest integer value less than or equal to the argument.

The argument can be of any built-in numeric type. If the argument is of type DECIMAL or REAL, it is converted to a double-precision floating-point number for processing by the function. If the argument is of type SMALLINT, INTEGER or BIGINT the argument value is returned.

The result of the function is:

• SMALLINT if the argument is SMALLINT
• INTEGER if the argument is INTEGER
• BIGINT if the argument is BIGINT
• DOUBLE if the argument is DOUBLE, DECIMAL or REAL. Decimal values with more than 15 digits to the left of the decimal will not return the desired integer value due to loss of precision in the conversion to DOUBLE.

The result can be null; if the argument is null, the result is the null value.