postgres统计每半个小时的数据

最新推荐文章于 2023-12-15 11:27:51 发布

冲啊浪啊

最新推荐文章于 2023-12-15 11:27:51 发布

阅读量1.6k

点赞数 1

分类专栏：数据库常用操作

本文链接：https://blog.csdn.net/qq_33709159/article/details/79779170

版权

数据库常用操作专栏收录该内容

3 篇文章 0 订阅

订阅专栏

SELECT overlay(
to_char(c_sys_date,'yyyy-mm-dd hh24:mi')
placing (
CASE WHEN CAST((cast(substr(CAST ((date_part('min',c_sys_date))/30 AS text), 1,1)as integer)*30) as text) = '30'
THEN CAST((cast(substr(CAST ((date_part('min',c_sys_date))/30 AS text), 1,1)as integer)*30) as text)
ELSE '00'
END )
from 15 for 2)as ia,
count(c_id) from h_user
GROUP BY ia
ORDER BY ia