实际的sql : SELECT SUM(tbl_dh.workingHours) AS workingHours, tbl_p.projectName FROM develop_hours AS tbl_dh INNER JOIN peojects AS tbl_p ON tbl_dh.projectName = tbl_p.id WHERE DATE_FORMAT (tbl_dh.date, '%Y-%m') = DATE_FORMAT(NOW(),'%Y-%m') GROUP BY projectName ORDER BY tbl_dh.date DESC
2.把date格式化为字符串
可以试一下这两个