ActiveRecord, MySQL with DATE_SUB ... how?

[eluser]cahva[/eluser]
You dont actually have to use DATE_SUB at all. This is perfectly valid query:

Code:

SELECT CURDATE() - INTERVAL 31 DAY;

For the AR this should work:

Code:

$this->db->where('(CURDATE() - INTERVAL 31 day) > created2');

If the query fails, you can check the last query with

Code:

echo $this->db->last_query();