Rails Console - Find where created at = certain day

Question

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 1

You can do it like this:

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

Answer 2

Try this,

User.where("Date(updated_at) = ?", "2018-02-9")