ruby-on-rails - 如何使用 Ruby on Rails 查找今天、昨天等的记录？

Question

我想找到所有记录，比如 Posts，今天用 Ruby on Rails 创建的，然后所有 Posts 昨天创建的，等等......我该怎么做？

谢谢，

凯文

Answer 1

尝试这个:

#Today
Posts.find(:all, conditions: { :created_at => Date.today...Date.today + 1 })
#Yesterday
Posts.find(:all, conditions: { :created_at => Date.today - 1...Date.today })

或者这个(在我看来最好):

#Today
Posts.find(:all, conditions: ["DATE(created_at) = ?", Date.today] )
#Yesterday
Posts.find(:all, conditions: ["DATE(created_at) = ?", Date.today - 1] )