+1  A: 

I don't bother with the date.to_s(:db) conversion. Working with pure Date and Datetime works fine for me.

Game.first(:conditions => ["starts_at <= ?", 3.days.from_now.to_date])
erik
Hi, that's true, I just used `date.to_s(:db)` to show the date format as "YYYY-MM-DD" instead of `Thu, 03 Dec 2009`. Thanks anyway :)
jpemberthy