Postgresql按天、周、月、年统计信息
– 当天select distinct to_char(created_time,‘yyyy-mm-dd’),count(status) from diku_mod_combine_catalogue.task where to_char(created_time,‘dd’)=to_char(CURRENT_DATE,‘dd’)group by to_char(created_time,‘yyyy-mm-dd’)order by to_char(created_time,‘yyyy-mm-dd’)–
原创
2021-08-13 18:01:59 ·
1959 阅读 ·
1 评论