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