MySQL Forums
Forum List  »  Newbie

Re: Aggregate with comparison
Posted by: Patricio Llaguno
Date: September 30, 2015 12:45PM

so i added a select like this


ADDTIME(FechaRegistro,(Select SEC_TO_TIME(Sum(TIME_TO_SEC(TiempoStd))) from Procesos)) as Cierre

which will get me somewhat a right answer, but not in the complete scenario, since im just adding the standard times, i need to do a comparison per time to see if P1 is greater than the 1st std time to get the needed time to add, how could i do this?

Options: ReplyQuote


Subject
Written By
Posted
September 29, 2015 12:41PM
September 29, 2015 04:23PM
Re: Aggregate with comparison
September 30, 2015 12:45PM
September 30, 2015 03:23PM
September 30, 2015 03:45PM
October 01, 2015 10:32PM


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.