Rails ActiveRecord date between

by

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)

More Related Contents:

  1. Rails extending ActiveRecord::Base
  2. How to change default timezone for Active Record in Rails?
  3. Rails :include vs. :joins
  4. ActiveRecord OR query
  5. Rails 4 scope to find parents with no children
  6. Random record in ActiveRecord
  7. What is the easiest way to duplicate an activerecord record?
  8. Rails: How can I set default values in ActiveRecord?
  9. How to express a NOT IN query with ActiveRecord/Rails?
  10. How can I avoid running ActiveRecord callbacks?
  11. Rails 4: List of available datatypes
  12. ActiveRecord OR query Hash notation
  13. Rails: Access to current_user from within a model in Ruby on Rails
  14. Rails – Nested includes on Active Records?
  15. Heroku Postgres Error: PGError: ERROR: relation “organizations” does not exist (ActiveRecord::StatementInvalid)
  16. Rails 3 SQLite3 Boolean false
  17. Add a reference column migration in Rails 4
  18. How to skip ActiveRecord callbacks? [duplicate]
  19. How do you write a migration to rename an ActiveRecord model and its table in Rails?
  20. Rails update_attributes without save?
  21. query , can not select column count
  22. Creating a PostgreSQL sequence to a field (which is not the ID of the record)
  23. Can I write PostgreSQL functions on Ruby on Rails?
  24. New data not persisting to Rails array column on Postgres
  25. Validate uniqueness of multiple columns
  26. Ruby on rails – Reference the same model twice?
  27. What is the difference between pluck and collect in Rails?
  28. Changing a column type to longer strings in rails
  29. Upgrading from Rails 2.3.8 to 4.0
  30. Force SSL using ssl_requirement in Rails 2 app

Leave a Comment