These links should contain all the reading material needed to solve your problem: http://book.cakephp.org/view/73/Retrieving-Your-Data http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html (assuming you're using MySQL) http://teknoid.wordpress.com/2008/09/29/dealing-with-calculated-fields-in-cakephps-find/ (because it'd be a calculated field)
Enjoy. ;) On Jun 18, 11:08 pm, keanoppy <[email protected]> wrote: > 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/- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
