SELECT * FROM mytable WHERE date < DATE_SUB(NOW(), INTERVAL 30 DAY);
How can i make this in Doctrine 1.2?
Asked
Active
Viewed 5,669 times
1
Dirk Fograust
- 75
- 2
- 5
-
Does it need to run on other systems then mysql? If not you just write it as above in DQL. – Hikaru-Shindo Mar 29 '12 at 08:26
1 Answers
5
Have you tried this answer ? how to make Doctrine_Expression ( doctrine 1.2 ) try to get last 7 days
$date = new Doctrine_Expression('DATE_SUB(NOW() , INTERVAL 30 DAY)');
$q->where('date > ' . $date);
