可以使用temporalAdd 函数,示例如下:
t = table(13:01:00 13:02:00 13:03:00 13:04:00 13:04:59 13:05:00 13:07:00 13:09:00 13:09:59 13:10:00 as pricetime, rand(100, 10) as value) res = select max(value) from t group by interval(pricetime, 5m, "none") as pricetime update res set pricetime = temporalAdd(pricetime, 5m)