iox.sqlInterval() function
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!
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:
Customers with an annual or support contract can contact InfluxData Support. Customers using a trial license can email trial@influxdata.com for assistance.