FLOOR
Rounds the given input down to the nearest integer.
Syntax
FLOOR(X)
Arguments
X
Type: numeric
A numeric value.
Returns
Type: same as input
X rounded down to the nearest integer.
Examples
| X | Output |
|---|---|
| 0.13523523 | 0.0 |
| -0.1 | -1.0 |
| -1.1 | -2.0 |
| 1 | 1 |
| 1 + 1 | 2 |
| 0 | 0 |
| -1 | -1 |
| -1 - 5 | -6 |