Function group: numeric function
FLOOR() (“round down to the floor”) determines the largest integer which is less than or equal to the specified numeric value. In the case of non-integer numeric values, FLOOR() always rounds down.
FLOOR ( expression )
expression
Fixed-point value of the type NUMERIC(p,s) or DECIMAL(p,s) if the number of decimal places s is greater than 0, otherwise a numeric expression.
expression may not be a multiple value with dimension > 1.
Result
When expression returns the NULL value, the result is the NULL value.
Otherwise:
The largest integer which is less than the specified numeric value.
Data type: NUMERIC(q+1,0) or DECIMAL(q+1,0) where q=MIN(31,p+1) if the number of decimal places s is greater than 0, otherwise like expression.
Examples
FLOOR (3,14) returns the value 3.
FLOOR (-3,14) returns the value -4.
FLOOR (10,54) returns the value 10.