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