FLOOR - Mathematical
Calculates the floor of the given (floating point) number
Input parameters
| Name | Type | Optional | Description |
|---|---|---|---|
x |
Number | False | Input Number |
Output
Number: ⌊x⌋
Usage
FLOOR(<x>)
Examples
Example 1
Query
LOAD tmp
AS ('': FLOOR(-0.9))
Result
-1.0
Example 2
Query
LOAD tmp
AS ('': FLOOR(0.3))
Result
0.0