Whats wrong with this query?
TIME_FORMAT(
DATE_ADD
(
TIMEDIFF(TIMEDIFF(u.hour_end, u.hour_begin),(u.hour_pauze)),
TIMEDIFF(TIMEDIFF(u.hour_end_o, u.hour_begin_o),(u.hour_pauze_o))
)
,'%H:%i') AS total,
I get the error:
#1305 - FUNCTION system.DATE_ADD does not exist
BTW: I am using version 5.0.51a.