ES|QL FLOOR function
number-
Numeric expression. If
null, the function returnsnull.
Round a number down to the nearest integer.
Note
This is a noop for long (including unsigned) and integer.
For double this picks the closest double value to the integer
similar to Math.floor.
| number | result |
|---|---|
| double | double |
| integer | integer |
| long | long |
| unsigned_long | unsigned_long |
ROW a=1.8
| EVAL a=FLOOR(a)
| a:double |
|---|
| 1 |