FLOOR
Description
Round down floating-point and fixed-point decimals to a specific number of digits and return the rounded floating-point or fixed-point number.
Syntax
FLOOR(<a>[, <d>])
Parameters
Parameter | Description |
---|---|
<a> | Floating-point (Double) or fixed-point (Decimal) parameter indicating the parameter to be rounded |
<d> | Optional, integer, indicates rounding to the target number of digits, a positive number means rounding to the next decimal point, a negative number means rounding to the next decimal point, and 0 indicates rounding to an integer. When not filled, it is equivalent to <d> = 0 . |
Return Value
Returns the largest rounded number less than or equal to <a>
according to the following rules.
Round to 1/(10^d)
digit, i.e., make the result divisible by 1/(10^d)
. If 1/(10^d)
is not exact, the rounding digit is the nearest number of the corresponding data type.
For an entry <a>
of type Decimal, assuming it is of type Decimal(p, s)
, the return value is:
Decimal(p, 0)
,if<d> <= 0
Decimal(p, <d>)
,if0 < <d> <= s
Decimal(p, s)
,if<d> > s
Alias
- DFLOOR
Examples
select floor(123.456);
+----------------+
| floor(123.456) |
+----------------+
| 123 |
+----------------+
select floor(123.456, 2);
+-------------------+
| floor(123.456, 2) |
+-------------------+
| 123.45 |
+-------------------+
select floor(123.456, -2);
+--------------------+
| floor(123.456, -2) |
+--------------------+
| 100 |
+--------------------+
select floor(123.45, 1), floor(123.45), floor(123.45, 0), floor(123.45, -1);
+------------------+---------------+------------------+-------------------+
| floor(123.45, 1) | floor(123.45) | floor(123.45, 0) | floor(123.45, -1) |
+------------------+---------------+------------------+-------------------+
| 123.4 | 123 | 123 | 120 |
+------------------+---------------+------------------+-------------------+
select floor(x, 2) from ( select cast(123.456 as decimal(6,3)) as x from numbers("number"="5") )t;
+-------------+
| floor(x, 2) |
+-------------+
| 123.45 |
| 123.45 |
| 123.45 |
| 123.45 |
| 123.45 |
+-------------+