Re: CakePHP 2.5.*- Find all posts by current month and day (m-d)

It does work in MySQL though, so it should work in CakePHP also :)
Enjoy, John

On Monday, 29 December 2014 14:42:38 UTC+2, John Andersen wrote:

Assuming I understand it correctly, then you want to query your posts, so that any event_date having a month = 12 and a day = 29, not taking into account the year, must be found. :)

Based on the above I would see if this is possible:
$this->Post->find('all', array('conditions' => array(
   'MONTH(Post.event_date)' => 12,
   'DAY(Post.event_date)' => 29
)));

Would that work for you? Haven't tested it as I do not have a 2.x version running.
Enjoy, John
[snip]

--
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 cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.