Unanswered: Mysql time calculation is not counting Sunday
I have a overview of hours worked by colleagues but for some reason the hours worked on Sunday are not added in the total amount worked hours in that week.
TIME_FORMAT(SEC_TO_TIME(SUM(TIME_TO_SEC(eind) - TIME_TO_SEC(start) - TIME_TO_SEC(pauze))), '%H:%i') AS week_totaal
WHERE user_id = ".$user_id." AND WEEKOFYEAR(datum) = $week AND YEAR(datum) = $year
GROUP BY WEEK(datum) , YEAR(datum)";