string() function

string() converts a value to a string type.

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



(Required) Value to convert.


Convert basic types to strings

string(v: true)

// Returns "true"
string(v: 1m)

// Returns "1m"
string(v: 2021-01-01T00:00:00Z)

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

Convert all values in a column to strings

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

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

View example input and output

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.