toInt() function
The toInt() function converts all values in the _value column to integers.
Function type: Type conversion
toInt()
Supported data types: Boolean | Duration | Float | Numeric String | Time | Uinteger
For duration and time values, toInt() returns the following:
| Input type | Returned value |
|---|---|
| Duration | The number of nanoseconds in the specified duration |
| Time | A nanosecond epoch timestamp |
To convert values in a column other than _value, define a custom function
patterned after the function definition,
but replace _value with your desired column.
Examples
from(bucket: "telegraf")
|> filter(fn:(r) =>
r._measurement == "mem" and
r._field == "used"
)
|> toInt()
Function definition
toInt = (tables=<-) =>
tables
|> map(fn:(r) => ({ r with _value: int(v: r._value) }))
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, the following resources are available:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.