Rails Console - Find where created at = certain day

ruby-on-rails ruby database postgresql rails-console

Seth · Jan 28, 2014 · Viewed 28.1k times · Source

With Ruby on Rails console, is it possible to query the database for all records created on a certain day?

something like

date = "january 5 2013"
users = User.find(:all, :conditions => {:created_at => date})

Answer

You can do it like this:

date = Date.parse('january 5 2013')
users = User.where(created_at: date.midnight..date.end_of_day)