toInt() function

toInt() converts all values in the _value column to integer types.

Supported types and behaviors

toInt() behavior depends on the _value column type:

_value typeReturned value
stringInteger equivalent of the numeric string
bool1 (true) or 0 (false)
durationNumber of nanoseconds in the specified duration
timeEquivalent nanosecond epoch timestamp
floatValue truncated at the decimal
uintInteger equivalent of the unsigned integer
Function type signature
(<-tables: stream[{A with _value: B}]) => stream[{A with _value: B, _value: int}]
For more information, see Function type signatures.



Input data. Default is piped-forward data (<-).


Convert a float _value column to integers

import "sampledata"

    |> toInt()

View example input and ouput

Convert a boolean _value column to integers

import "sampledata"

    |> toInt()

View example input and ouput

Convert a uinteger _value column to an integers

import "sampledata"

    |> toInt()

View example input and ouput

Was this page helpful?

Thank you for your feedback!

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.