FLOOR returns the largest integer value less than or equal to x.
|
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.