当我想要获取今天创建的所有记录时,我应该如何编写条件语句?
发布于 2010-05-27 17:02:23
Post.where(created_at: Time.zone.now.beginning_of_day..Time.zone.now.end_of_day)
PS:这个答案已经被Harish Shetty修改为比我更好的答案。因为我的回答是被接受的。我已经更新了这个答案以获得社区支持。
发布于 2010-05-27 17:01:55
MySQL:
Model.all :condition => ["DATE(created_at) = ?", Date.today] # rails 2
Model.where("DATE(created_at) = ?", Date.today) # rails 3
PostgreSQL:
Model.all :condition => ["created_at::date = ?", Date.today] # rails 2
Model.where("created_at::date = ?", Date.today) # rails 3
发布于 2019-02-27 02:47:09
Rails5.1有一个在这里很有用的all_day
助手。
Post.where(created_at: Date.today.all_day)
或
Post.where(created_at: Date.parse("YYYY-MM-DD").all_day)
https://stackoverflow.com/questions/2919720
复制相似问题