| 取整 | toStartOfMinute/Hour/Day/Week/Month/Quarter/Year |
|---|---|
| 自定义 | toStartOfInterval(ts, INTERVAL 5 MINUTE) 或 date_trunc('minute', ts) |
| 运算 | now()、today()、dateDiff('day', a, b)、date_add/date_sub 或 ts + INTERVAL 1 DAY |
示例
示例
SELECT
toStartOfInterval(ts, INTERVAL 5 MINUTE) AS bucket,
count() AS cnt
FROM metrics
WHERE ts >= now() - INTERVAL 1 HOUR
GROUP BY bucket
ORDER BY bucket;时间列统一用 UTC 或固定时区存储，展示层再转换；函数 toTimeZone 可做时区切换。