ActiveRecord DateTime type search range.

rubyonrails-talk
1

i have a table full of entries that each have a datetime field with a date and timestamp... how would i use activerecord to get all entries from say 2008-08-12 12:00:00 to 2009-08-12 12:00:00.. i've tried searching the table in every way i can think of and can't seem to find it online

2

i have a table full of entries that each have a datetime field with a date and timestamp... how would i use activerecord to get all entries from say 2008-08-12 12:00:00 to 2009-08-12 12:00:00.. i've tried searching the table in every way i can think of and can't seem to find it online

SomeClass.find :all, :conditions => {:date_field =>
(first_date..second_date)} or SomeClass.find :all, :conditions => ['date_field > ? and date_field
< ?', first_date, second_date]

Fred

3

warning... I have been using range with ActiveSupport::TimeWithZone values (start_at, end_at) stored in DateTime columns in my DB check what this range will output : period = start_at..end_at vs period = Date.parse(start_at.to_s)..Date.parse(end_at.to_s) you will be surprised....