FLOOR returns the largest integer value less than
or equal to
x.
![Read syntax diagram](./c.gif)
>>-FLOOR(x)----------------------------------------------------><
- x
- Real expression.
The mode, base, scale, and precision of the result match the argument.
Except when
x is fixed-point with precision (
p,q),
the precision of the result is given by:
(min(n,max(p-q+1,1)),0)
where n is the maximum number of digits allowed and is N for FIXED
DECIMAL or M for FIXED BINARY.