int() function - Influxdb

int() converts a value to an integer type.

int() behavior depends on the input data type:

Input type	Returned value
string	Integer equivalent of the numeric string
bool	1 (true) or 0 (false)
duration	Number of nanoseconds in the specified duration
time	Equivalent nanosecond epoch timestamp
float	Value truncated at the decimal
uint	Integer equivalent of the unsigned integer

Function type signature

(v: A) => int

{{% caption %}} For more information, see Function type signatures. {{% /caption %}}

Parameters

v

({{< req >}}) Value to convert.

Examples

Convert basic types to integers
Convert all values in a column to integers

Convert basic types to integers

int(v: 10.12)

// Returns 10
int(v: "3")

// Returns 3
int(v: true)

// Returns 1
int(v: 1m)

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

Convert all values in a column to integers

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

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

Input data

_time	*tag	exampleCol
2021-01-01T00:00:00Z	t1	-2.18
2021-01-01T00:00:10Z	t1	10.92
2021-01-01T00:00:20Z	t1	7.35
2021-01-01T00:00:30Z	t1	17.53
2021-01-01T00:00:40Z	t1	15.23
2021-01-01T00:00:50Z	t1	4.43

_time	*tag	exampleCol
2021-01-01T00:00:00Z	t2	19.85
2021-01-01T00:00:10Z	t2	4.97
2021-01-01T00:00:20Z	t2	-3.75
2021-01-01T00:00:30Z	t2	19.77
2021-01-01T00:00:40Z	t2	13.86
2021-01-01T00:00:50Z	t2	1.86

Output data

_time	exampleCol	*tag
2021-01-01T00:00:00Z	-2	t1
2021-01-01T00:00:10Z	10	t1
2021-01-01T00:00:20Z	7	t1
2021-01-01T00:00:30Z	17	t1
2021-01-01T00:00:40Z	15	t1
2021-01-01T00:00:50Z	4	t1

_time	exampleCol	*tag
2021-01-01T00:00:00Z	19	t2
2021-01-01T00:00:10Z	4	t2
2021-01-01T00:00:20Z	-3	t2
2021-01-01T00:00:30Z	19	t2
2021-01-01T00:00:40Z	13	t2
2021-01-01T00:00:50Z	1	t2