cakephp 今日の日付で条件を指定する方法
'Model.created BETWEEN ? AND ?' => array(date("Y-m-d")." 00:00:00", date("Y-m-d")." 23:59:59")
・今日の日付でhoge_noが一番高かったもののcolumnを取得
return $this->find('first', array( 'conditions' => array( 'Model.created BETWEEN ? AND ?' => array(date("Y-m-d")." 00:00:00", date("Y-m-d")." 23:59:59") ), 'fields' => array( 'Model.column' ), 'order' => array( 'Model.hoge_no'=>"DESC" ) ));
↓SQLにすると
SELECT `Model`.`column`
FROM `Model` AS `Model`
WHERE `Model`.`created` BETWEEN '2010-11-01 00:00:00' AND '2010-11-01 23:59:59'
ORDER BY `Model`.`hoge_no` DESC
LIMIT 1