I also use 'Y-m-d H:i:s' format, the Time helper makes it nice and easy to work with these fields anyhow, the former is more readable for an end user and also I don't think the benefits of switching it to numerical are worth the effort.
http://book.cakephp.org/2.0/en/core-libraries/helpers/time.html#TimeHelper::daysAsSql On 24 March 2014 10:32, José Lorenzo <[email protected]> wrote: > I use '2014-03-01 23:25:03' > > > On Monday, March 24, 2014 5:26:17 AM UTC+1, advantage+ wrote: >> >> When comparing dates as a value in the query it looks like this >> >> `created` < '2014-03-01 23:25:03' >> >> or >> >> `created` >= '2014-02-23 23:25:03' >> >> >> >> Is that the best way? *'2014-03-01 23:25:03' *does not look numical. >> >> Or is it best to save that created value as strtotime() so you actually >> have a numerical value. >> >> 1393716303 since comparing if something is great / less than seems more >> appropriate. >> >> >> >> I have tried both ways and each worked out exactly the same but just >> wondering which would be the best method and why? >> >> >> >> Thanks, >> >> Dave >> > -- > Like Us on FaceBook https://www.facebook.com/CakePHP > Find us on Twitter http://twitter.com/CakePHP > > --- > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/cake-php. > For more options, visit https://groups.google.com/d/optout. > -- Kind Regards Stephen Speakman -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.
