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
On Monday, 29 December 2014 11:15:46 UTC+2, Salines wrote:
-- 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
On Monday, 29 December 2014 11:15:46 UTC+2, Salines wrote:
$this->Post->find('all',array('conditions' => array('Post.event_date' => '12-29')); // show posts where is Post.event_date like 12-29.event_date fields is date type (Y-m-d), where they are stored dates of significant events.In other words I need to show the anniversary.Except using virtual fields where I will show formatted date without year (m-d), is there a more elegant solution?Thanks
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.
No comments:
Post a Comment