toUInt() function

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

Supported types and behaviors

toUInt() behavior depends on the _value column type:

_value typeReturned value
stringUInteger 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
intUInteger equivalent of the integer
Function type signature
(<-tables: stream[{A with _value: B}]) => stream[{A with _value: B, _value: uint}]
For more information, see Function type signatures.



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


Convert a float _value column to uintegers

import "sampledata"

    |> toUInt()

View example input and ouput

Convert a boolean _value column to uintegers

import "sampledata"

    |> toUInt()

View example input and ouput

Convert a uinteger _value column to an uintegers

import "sampledata"

    |> toUInt()

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.