ROUND - Mathematical
Rounds the given (floating point) number to the nearest integer number
Input parameters
| Name | Type | Optional | Description |
|---|---|---|---|
x |
Number | False | Input Number |
Output
Number: round(x)
Usage
ROUND(<x>)
Examples
Example 1
Query
LOAD tmp
AS ('': ROUND(-0.9))
Result
-1.0
Example 2
Query
LOAD tmp
AS ('': ROUND(0.3))
Result
0.0