How to Calculate time differences in the modal class?

2011-11-15 Thread Gerrit
Hello, I've start and end field as datetime in my database. Now I want to calculate the difference in hours as a virtual field. Is that possible?? Thx! -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site

Re: How to Calculate time differences in the modal class?

2011-11-15 Thread Graham Weldon
$virtualFields = array( 'difference' = 'HOUR(TIMEDIFF(end, start))' ); Cheers, Graham Weldon http://grahamweldon.com e. gra...@grahamweldon.com p. (+61) 0407 017 293 Skype: grahamweldon On Tuesday, 15 November 2011 at 8:13 PM, Gerrit wrote: Hello, I've start and end field as datetime in