活动记录 - 查找记录与今日前created_at今日、created_at

2023-09-09 22:07:06 作者:悲伤的帅哥

我想获得的所有记录,其中created_at字段小于今天(日期)。 有什么样:

  MyTable.find_by_created_at(小于2.days.ago)
 

解决方案

基本的ActiveRecord(AR):

  MyModel.where([created_at<,2.days.ago])
 
广州南站现在是不是可以直接只用身份证上下车

AR与阿雷尔:

  MyModel.where(MyModel.arel_table [:created_at] .LT(2.days.ago))
 

等同于previous,但使用此薄层超过阿雷尔:

  MyModel.where(为MyModel [:created_at]< 2.days.ago)
 

使用 squeel :

  MyModel.where {created_at< 2天前 }
 

I want to get all records where the created_at field is less than today (a date). Is there anything like:

MyTable.find_by_created_at(< 2.days.ago)

解决方案

Basic ActiveRecord (AR):

MyModel.where(["created_at < ?", 2.days.ago])

AR with Arel:

MyModel.where(MyModel.arel_table[:created_at].lt(2.days.ago))

Equivalent to the previous, but using this thin layer over Arel:

MyModel.where(MyModel[:created_at] < 2.days.ago)

Using squeel:

MyModel.where { created_at < 2.days.ago }

 
精彩推荐
图片推荐