ruby-on-rails - 返回今天和昨天在 ruby​​ on rails 中完成的表列

Question

我正在尝试获取仅在今天、昨天和前天创建的记录。我的模型是 Visitor

对于今天创建的项目，我正在尝试

Visitor.where(created_at: Date.today)

然后对于昨天创建的项目，我正在尝试

Visitor.where(created_at: Date.yesterday)

但是它不起作用，因为 Created_at 列采用时间戳形式，而 Date.today 或昨天采用日期格式。我怎样才能使这项工作。还有如何获取前天创建的元素？

Answer 1

#Today
Visitor.where("DATE(created_at) = ?", Date.today)
#Yesterday
Visitor.where("DATE(created_at) = ?", Date.yesterday)

或者:

#Today
Visitor.where(created_at: Date.today...Date.today+1)
#Yesterday
Visitor.where(created_at: Date.yesterday...Date.today)

引用:How can I find records from today, yesterday and so on with Ruby on Rails?