floor
floor(number)
The FLOOR function has the following arguments:
numberThe number or integer of which you want the floor value
The floor function returns the largest (closest to positive infinity) double value that is less than or equal to the argument and is equal to a mathematical integer. The function will return a double precision number.
|
Formula |
Description |
Result |
|---|---|---|
|
floor(0.9) |
Round down 0.9 to the nearest integer |
0.0 |
| floor(-5.6) | Round down -5.6 to the nearest integer | -6.0 |
| floor(10.0) | Round down 10.o to the closest integer | 10.0 |