Re: Aggregate with comparison
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?
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
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.