mysql按日、月、周、季度分组
按日分组：select DATE_FORMAT(o.OrderDate,"%Y%m%d") weeks,count(*) count from orders o group by weeks;
按月分组：select DATE_FORMAT(o.OrderDate,"%Y%m") weeks,count(*) count from orders o group by weeks;
按月分组：select DATE_FORMAT(o.OrderDate,"%Y%m") weeks,count(*) count from orders o group by weeks;
按周分组： select DATE_FORMAT(o.OrderDate,"%Y_%u") weeks,count(*) count from orders o group by weeks;
按季度分组：select CONCAT(YEAR(o.OrderDate),"_",quarter(o.OrderDate)) qu,count(*) count from orders o group by qu;
获取当月的最后一天 select LAST_DAY(o.OrderDate) FROM orders o
声明：该文观点仅代表作者本人，牛骨文系教育信息发布平台，牛骨文仅提供信息存储空间服务。
