Floor
The Floor() function rounds down to the closest integral number (integer number without decimals) smaller than or equal to the given number.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns the closest integral value that is smaller than or equal to number.
Returns Invalid expression if the parameter is not a valid number.
Syntax
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| numeric | a numeric value. |
Examples
| Function call | Result |
|---|---|
Floor(5) | 5 |
Floor(5.999) | 5 |
Floor(-123.89) | -124 |
Last updated