在Doctrine Symfony学习30天

Question

i would like add clause where - max 30 days from now.

in database i have timestamp:

2011-08-30 20:29:35

id  | name | date
1   | aaa  | 2011-08-30 20:29:35
2   | vvv  | 2011-08-10 20:29:35
3   | bbb  | 2011-07-10 20:29:35
4   | fff  | 2011-08-14 20:29:35
5   | ddd  | 2011-06-10 20:29:35


$query = Doctrine_Core::getTable('News')->createQuery('a');
$query->addWhere('date ????????');

How can i get all news recent 30 days?

Answer 1

$query->andWhere('date > ?', date('Y-m-d', time() - 60*60*24*30))