How to group by and order By datetime Cakephp?

Question

Hi how do I group by and order by a datetime field with CakePHP?

Answer 1

Did you already make an attempt and did it fail?

I don't have a CakePHP installation around to verify, but my first guess would be to state in the controller:

$this->Model->find("all", array('order'=>'Model.datetimeFieldName'));

I'd expect Cake to handle the ordering.

Answer 2

An even better way to do this is to specify the order in the Model.

http://book.cakephp.org/view/440/order

You can still of course override that in the controller later.

Answer 3

$this->Post->find('all', array(
    'order' => array('Post.date' => 'DESC'),
    'group' => 'Post.date'
));