Mobile DBMS version: this function is not permitted with DB2.
Syntax
FLOOR(NumericArgument)
Description
The FLOOR SQL scalar function returns the largest integer value less than or equal to NumericArgument.
The argument must be a value of any built-in numeric data type.
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 DECIMAL or NUMERIC.
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.
Example
FLOOR(25.76) returns 25
List of SQL scalar functions by topic