Advertisement

PostgreSQL提取星期与月份数据

阅读量：
复制代码 
    select EXTRACT (week FROM timestamp '2022-01-07')
    
    SELECT date_part('week',TIMESTAMP '2022-01-11') a, -- 获取周

pg可依据日、周、月等时间维度对数据进行统计分析

复制代码 
    SELECT date_trunc('WEEK', insert_time) as insertDate, SUM(data_increment) as dataTotal,SUM(human_increment) as humanTotal  from human_data_sum t where t.idtype=? GROUP BY insertDate ORDER BY insertDate DESC
    
    SELECT date_trunc('MONTH', insert_time) as insertDate, SUM(data_increment) as dataTotal,SUM(human_increment) as humanTotal  from human_data_sum t where t.idtype=? GROUP BY insertDate O

全部评论 (0)

还没有任何评论哟~

相关文章推荐