Hey all, I have a model Post with a datetime posted_on attribute. What's the best way to find all the posts that were posted x days, let's say 5 days ago?
thanx in advance
Pat
oops...
recent_posts = Post.find(:all, :conditions => "posted_on > #{5.days.ago.to_s(:db)}")
jdswift wrote:
recent_posts = Post.find(:all, :conditions => "posted_on > #{5.days.ago.to_s(:db)}")
Don't you need more quotes?
Which of these would work?
:conditions => ['posted_on > ?', 5.days.ago.to_s(:db)]
:conditions => ['posted_on > ?', 5.days.ago]
