int() function
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
For more information, see Function type signatures.
Parameters
v
(Required) Value to convert.
Examples
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 covert a column value to a integer type.
data
|> map(fn: (r) => ({r with exampleCol: int(v: r.exampleCol)}))
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for Flux and this documentation. To find support, use the following resources:
InfluxDB Cloud customers can contact InfluxData Support.