any query to capture the date values of two different rows? On Jun 19, 10:46 am, stefano <[email protected]> wrote: > try with mktime() > > mktime(5/6/2009) - mktime(3/6/2009) > > maybe :P > > On Thu, Jun 18, 2009 at 9:26 PM, keanoppy<[email protected]> wrote: > > > let say this database of mine got 2 columns, 1 is planned date,another > > is actual date. > > at the first row, the planned date is 3/6/2009 and actual is 4/6/2009 > > at the second row, they are 5/6/2009 and 10/6/2009 respectively > > how can i create a view to determine the duration between the two > > dates between rows respectively? > > as in planned duration:5/6/2009 - 3/6/2009 and actual duration is > > 10/6/2009 - 4/6/2009 > > -- > Stefano Salvatori M.http://stefano.salvatori.cl/
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
