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 type Returned value
string Integer equivalent of the numeric string
bool 1 (true) or 0 (false)
duration Number of nanoseconds in the specified duration
time Equivalent nanosecond epoch timestamp
float Value truncated at the decimal
uint Integer 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.