Active record and date in where statement

[eluser]KingSkippus[/eluser]
[quote author="smilie" date="1279743258"]
However, with active record code:

Code:

$this->db1->where('created >=',date("Y-m-d H:i:s",strtotime("-1 day")));

I receive no results from the query... Why is this?
I have tried to escape it - but no prevail.
[/quote]

If you put this line after your query executes, what do you get?

Code:

echo '<pre>'.htmlentities($this->db1->last_query()).'</pre>';

Maybe we can find out what it is munging up to produce no results.