iox.sqlInterval() function

  • <nil> 0.192.0+

iox.sqlInterval() is experimental and subject to change at any time.

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
(d: A) => string

For more information, see Function type signatures.

Parameters

d

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

Examples

Convert a duration to a SQL interval

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

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)

Was this page helpful?

Thank you for your feedback!