PostgreSQL 按周、按15分钟 分组统计

Question

Answer 1

解决了！
以下是查询 周的SQL：
SELECT
to_char ( cda.time_point, 'yyyy ' ) || EXTRACT ( WEEK FROM cda.time_point ) :: INTEGER AS d,
sum( cda.temperature ) AS temperature,
cda.time_point AS times
FROM
config_climate_detail AS cda
LEFT JOIN config_climate cl ON cda.pid = cl.id
WHERE
1 = 1
AND to_char ( cda.time_point, 'YYYY-MM-DD HH24:MI:SS' ) BETWEEN '2014-01-01 00:00:00' AND '2018-12-12 00:00:00'
GROUP BY
d,
times
ORDER BY
d,
times DESC