Cakephp如何仅按日期和月份订购

Question

I have a contact table with date field for birthdate.

Now I would like to show list of birthday within next week. I can show it, but the order is based on the year.

How can I order the data, just based on month and day only?

$sideBarTaskSuggestion = 
$this->Project->Contact->find('all', array(
   'conditions' => array(
      'Contact.group_id' => $this->Session->read('Auth.User.group_id'),
      'Contact.birthdate NOT' => null,
      'AND' => array(
           array('Contact.birthdate NOT' => null),
           array('Contact.birthdate + INTERVAL EXTRACT(YEAR FROM NOW()) - 
              EXTRACT(YEAR FROM Contact.birthdate) YEAR <=' => date('Y-m-d', 
                 strtotime('+1 week'))),
           array('Contact.birthdate + INTERVAL EXTRACT(YEAR FROM NOW()) -
              EXTRACT(YEAR FROM Contact.birthdate) YEAR >=' => date('Y-m-d')),
      )
    ),
   'order' => 'Contact.birthdate DESC'
)
);

Answer 1

When you say you want 'order the data, just based on month and day only?', I assume you mean:

• Nov 22, 2013
• Oct 21, 1922
• Mar 5, 2000
• Jan 31, 2001
• Jan 1, 1990

Then try this: 'order' => 'DAYOFYEAR(Contact.birthdate) DESC'