iox.sqlInterval() 函数
iox.sqlInterval() 是实验性的，并且随时可能更改。
iox.sqlInterval() 将 duration 值转换为 SQL interval 字符串。
Duration 值必须为正数才能用作 SQL interval 字符串。
Function type signature
(d: A) => string
For more information, see Function type signatures。
Parameters
d
（必需）要转换为 SQL interval 字符串的 Duration 值。
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.