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 -~----------~----~----~----~------~----~------~--~---
