toDouble()
Converts a value to a double-precision floating-point number.
| Syntax | toDouble(<value>) |
||
| Arguments | Name | Type | Description |
<value> |
Numeric, Textual | The input value | |
| Return Type | DOUBLE |
||
uncollect [-36.123456789012345, "-36.123abc", "a10"] as item
return table(item, toDouble(item))
Result:
| item | toDouble(item) |
|---|---|
| -36.1234567890123 | 36.1234567890123 |
| -36.123abc | -36.123 |
| a10 | 0 |
toFloat()
Converts a value to a single-precision floating-point number.
| Syntax | toFloat(<value>) |
||
| Arguments | Name | Type | Description |
<value> |
Numeric, Textual | The input value | |
| Return Type | FLOAT |
||
uncollect [-36.123456789012345, "-36.123abc", "a10"] as item
return table(item, toFloat(item))
Result:
| item | toFloat(item) |
|---|---|
| -36.1234567890123 | -36.12346 |
| -36.123abc | -36.123 |
| a10 | 0 |
toInteger()
Converts a value to a 64-bit integer.
| Syntax | toInteger(<value>) |
||
| Arguments | Name | Type | Description |
<value> |
Numeric, Textual | The input value | |
| Return Type | INT64 |
||
uncollect [-36.123456789012345, "-36.123abc", "a10"] as item
return table(item, toInteger(item))
Result:
| item | toInteger(item) |
|---|---|
| -36.1234567890123 | -36 |
| -36.123abc | -36 |
| a10 | 0 |
toString()
Converts a value to a string.
| Syntax | toString(<value>) |
||
| Arguments | Name | Type | Description |
<value> |
Numeric, Textual | The input value | |
| Return Type | STRING |
||
uncollect [24, 0.000000001, [23,21]] as item
return toString(item)
Result:
| toString(item) |
|---|
| 24 |
| 1e-09 |
| [23,21] |