---
title: iox.sqlInterval() function
description: iox.sqlInterval() converts a duration value to a SQL interval string.
url: https://docs.influxdata.com/flux/v0/stdlib/experimental/iox/sqlinterval/
estimated_tokens: 1170
product: Flux
version: v0
---

# iox.sqlInterval() function

-   Flux 0.192.0+
-   View InfluxDB support

`iox.sqlInterval()` is experimental and [subject to change at any time](/flux/v0/stdlib/experimental/#experimental-packages-are-subject-to-change).

`iox.sqlInterval()` converts a duration value to a SQL interval string.

Duration values must be positive to work as a SQL interval string.

##### Function type signature

```js
(d: A) => string
```

For more information, see [Function type signatures](/flux/v0/function-type-signatures/).

## Parameters

### d

(Required) Duration value to convert to SQL interval string.

## Examples

-   [Convert a duration to a SQL interval](#convert-a-duration-to-a-sql-interval)
-   [Use a Flux duration to define a SQL interval](#use-a-flux-duration-to-define-a-sql-interval)

### Convert a duration to a SQL interval

```js
import "experimental/iox"

iox.sqlInterval(
    d: 1y2mo3w4d5h6m7s8ms,
)// Returns 1 years 2 months 3 weeks 4 days 5 hours 6 minutes 7 seconds 8 milliseconds

```

### Use a Flux duration to define a SQL interval

```js
import "experimental/iox"

windowInterval = 1d12h
sqlQuery = "
SELECT
  DATE_BIN(INTERVAL '${iox.sqlInterval(
        d: windowInterval,
    )}', time, TIMESTAMP '2023-01-01T00:00:00Z') AS time_bin,
  COUNT(field1)
FROM
  measurement
GROUP BY
  time_bin
"

iox.sql(bucket: "example-bucket", query: sqlQuery)
```

[sql](/flux/v0/tags/sql/) [type-conversions](/flux/v0/tags/type-conversions/)