SELECT p.`name`,YEAR(p.beginTime) AS Y,MONTH(p.beginTime) AS M ,COUNT(p.name) AS days,SUM(TIMESTAMPDIFF(HOUR,p.beginTime,p.endTime)) AS hours FROM person p GROUP BY YEAR(p.beginTime),MONTH(p.beginTime),p.`name` ORDER BY hours DESC;
按月份统计工时
最新推荐文章于 2024-05-11 22:06:07 发布