Rails ActiveRecord date between

ruby-on-rails rails-activerecord ruby-on-rails-2
rtacconi picture rtacconi · Mar 4, 2010 · Viewed 165k times · Source

I need to query comments made in one day. The field is part of the standard timestamps, is created_at. The selected date is coming from a date_select.

How can I use ActiveRecord to do that?

I need something like:

"SELECT * FROM comments WHERE created_at BETWEEN '2010-02-03 00:00:00' AND '2010-02-03 23:59:59'"

Answer

ndbroadbent picture ndbroadbent · Oct 18, 2012

Just a note that the currently accepted answer is deprecated in Rails 3. You should do this instead:

Comment.where(:created_at => @selected_date.beginning_of_day..@selected_date.end_of_day)

Or, if you want to or have to use pure string conditions, you can do:

Comment.where('created_at BETWEEN ? AND ?', @selected_date.beginning_of_day, @selected_date.end_of_day)

Related questions

How do you delete an ActiveRecord object?

How do you delete an ActiveRecord object? I looked at Active Record Querying and it does not have anything on deleting that I can see. Delete by id, Delete the current object like: user.remove, Can you delete based on …

Read More
Rails 4: List of available datatypes

Where can I find a list of data types that can be used in Ruby on Rails 4? Such as text string integer float date I keep learning about new ones and I'd love to have a list I could easily …

Read More
Add a reference column migration in Rails 4

A user has many uploads. I want to add a column to the uploads table that references the user. What should the migration look like? Here is what I have. I'm not sure if I should use (1) :user_id, :int …

Read More