float() function

float() converts a value to a float type.

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



(Required) Value to convert.


Convert a string to a float

float(v: "3.14")// Returns 3.14

Convert a scientific notation string to a float

float(v: "1.23e+20")// Returns 1.23e+20 (float)

Convert an integer to a float

float(v: "10")// Returns 10.0

Convert all values in a column to floats

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

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

View example input and output

Was this page helpful?

Thank you for your feedback!

Introducing InfluxDB 3.0

The new core of InfluxDB built with Rust and Apache Arrow. Available today in InfluxDB Cloud Dedicated.

Learn more

State of the InfluxDB Cloud Serverless documentation

The new documentation for InfluxDB Cloud Serverless is a work in progress. We are adding new information and content almost daily. Thank you for your patience!

If there is specific information you’re looking for, please submit a documentation issue.