MySQL Forums
Forum List  »  General

Re: bug (5.6.22) in ADDTIME?
Posted by: sebastian gomez
Date: January 23, 2015 01:04PM

thanks for the answer, but even if I delete all the fields of the query, except the one by I'm grouping by and the operation, it goes wrong:

SELECT a.codasig_cita, ADDTIME(a.hora_cita, SEC_TO_TIME(SUM(TIME_TO_SEC(pe.duracion))) ) AS "add (wrong)"
FROM asig_cita2 a, citas_proc_empl2 cpe, proc_empl2 pe
WHERE cpe.codproc_empl=pe.codproc_empl AND a.codasig_cita=cpe.codasig_cita
GROUP BY a.codasig_cita

so, that's not the problem

Options: ReplyQuote


Subject
Written By
Posted
January 23, 2015 10:46AM
January 23, 2015 12:56PM
January 23, 2015 05:48PM
January 26, 2015 12:51PM
January 26, 2015 03:02PM
January 23, 2015 05:55PM
Re: bug (5.6.22) in ADDTIME?
January 23, 2015 01:04PM
January 26, 2015 03:17PM
January 26, 2015 03:54PM
January 26, 2015 06:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.