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 | ||
UQLuncollect [-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 |
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 | ||
UQLuncollect [-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 |
Converts a value to a 64-bit integer.
| Syntax | toInteger(<value>) | ||
| Arguments | Name | Type | Description |
<value> | Numeric, Textual | The input value | |
| Return Type | INT64 | ||
UQLuncollect [-36.123456789012345, "-36.123abc", "a10"] as item return table(item, toInteger(item))
Result:
| item | toInteger(item) |
|---|---|
| -36.1234567890123 | -36 |
| -36.123abc | -36 |
| a10 | 0 |
Converts a value to a string.
| Syntax | toString(<value>) | ||
| Arguments | Name | Type | Description |
<value> | Numeric, Textual | The input value | |
| Return Type | STRING | ||
UQLuncollect [24, 0.000000001, [23,21]] as item return toString(item)
Result:
| toString(item) |
|---|
| 24 |
| 1e-09 |
| [23,21] |