time() function

time() converts a value to a time type.

Function type signature
(v: A) => time
For more information, see Function type signatures.



(Required) Value to convert.

Strings must be valid RFC3339 timestamps. Integer and unsigned integer values are parsed as nanosecond epoch timestamps.


Convert a string to a time value

time(v: "2021-01-01T00:00:00Z")// Returns 2021-01-01T00:00:00Z (time)

Convert an integer to a time value

time(v: 1640995200000000000)// Returns 2022-01-01T00:00:00Z

Convert all values in a column to time

If converting the _value column to time types, use toTime(). If converting columns other than _value, use map() to iterate over each row and time() to covert a column value to a time type.

    |> map(fn: (r) => ({r with exampleCol: time(v: r.exampleCol)}))

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.