limiting query with created_at?

Taylor Strait wrote:

I have no idea why this isn't working but maybe a new set of eyes can help. I want to only collect posts from yesterday:

    Post.find( :all,                :conditions => "posts.created_at > #{(1.day.ago).to_i}",

I though all databases only treated dates as formatted strings. Try this:

                :conditions => "posts.created_at > '#{1.day.ago.to_s :db}'",

After that guess, I don't know how a database will handle date inequalities!