实际的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格式化为字符串
可以试一下这两个