Documentation

bool() function

bool() converts a value to a boolean type.

Function type signature
(v: A) => bool

For more information, see Function type signatures.

Parameters

v

(Required) Value to convert.

Examples

Convert strings to booleans

bool(v: "true")

// Returns true
bool(v: "false")// Returns false

Convert numeric values to booleans

bool(v: 1.0)

// Returns true
bool(v: 0.0)

// Returns false
bool(v: 1)

// Returns true
bool(v: 0)

// Returns false
bool(v: uint(v: 1))

// Returns true
bool(v: uint(v: 0))// Returns false

Convert all values in a column to booleans

If converting the _value column to boolean types, use toBool(). If converting columns other than _value, use map() to iterate over each row and bool() to convert a column value to a boolean type.

data
    |> map(fn: (r) => ({r with powerOn: bool(v: r.powerOn)}))

View example input and output


Was this page helpful?

Thank you for your feedback!


New in InfluxDB 3.7

Key enhancements in InfluxDB 3.7 and the InfluxDB 3 Explorer 1.5.

See the Blog Post

InfluxDB 3.7 is now available for both Core and Enterprise, landing alongside version 1.5 of the InfluxDB 3 Explorer UI. This release focuses on giving developers faster visibility into what their system is doing with one-click monitoring, a streamlined installation pathway, and broader updates that simplify day-to-day operations.

For more information, check out:

InfluxDB Docker latest tag changing to InfluxDB 3 Core

On February 3, 2026, the latest tag for InfluxDB Docker images will point to InfluxDB 3 Core. To avoid unexpected upgrades, use specific version tags in your Docker deployments.

If using Docker to install and run InfluxDB, the latest tag will point to InfluxDB 3 Core. To avoid unexpected upgrades, use specific version tags in your Docker deployments. For example, if using Docker to run InfluxDB v2, replace the latest version tag with a specific version tag in your Docker pull command–for example:

docker pull influxdb:2