floor

floor(`number`

)

The FLOOR function has the following arguments:

`number`

The 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 |