search for: date_col

Here''s my problem. I have an ''Item'' model with a date column called "inserted_on" formatted as "yyyy-mm-dd hh:mm:ss:t". I want to find all records that were inserted more than 30 days ago. How would I say that using the Item.find ( :all .....) method? I don''t fully understand the syntax. I tried @result = Item.find( :all, :conditions =>

I have the following: Table Products: With a column called "purchased_at" of type "datetime". Products.find(:all, :conditions => ["? - purchased_at >= 120", Time.now]) Why doesn''t that work? What I''m trying to do is find records that were purchased less than or equal to 2 minutes ago. Thanks for your help. -- Posted via