2025-01-14 17:32
实际的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
2025-01-13 14:37
@超级管理员 实际使用时并没有把date字段查出来，只是我测试的时候查询了一下，我该怎么解决接口返回的数据错误的问题？workingHours的值，实际不是455.0
