mysql,postgresql 按 年、季、月、周、天 统计
mysql按日SELECT COUNT(*),DATE(CreateTime) FROM t_voipchannelrecord WHERE YEAR(CreateTime)='2016' GROUP BY DAY(CreateTime)按周SELECT COUNT(*),WEEK(CreateTime) FROM t_voipchannelrecord WHERE MONTH...
原创
2019-06-04 08:15:23 ·
10203 阅读 ·
3 评论