toTime() function

The toTime() function converts all values in the _value column to times.

Function type: Type conversion


Supported data types: Integer | String | Uinteger

toTime() assumes all numeric input values are nanosecond epoch timestamps.

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.


from(bucket: "telegraf")
  |> filter(fn:(r) =>
    r._measurement == "mem" and
    r._field == "used"
  |> toTime()

Function definition

toTime = (tables=<-) =>
    |> map(fn:(r) => ({ r with _value: time(v:r._value) }))

Used functions: map(), time()

Cloud or OSS?

InfluxDB OSS 2.0 now generally available!

InfluxDB OSS 2.0 is now generally available and ready for production use. See the InfluxDB OSS 2.0 release notes.

For information about upgrading to InfluxDB OSS 2.0, see: