我需要查询一天内的 comments .该字段是标准时间戳的一部分,为created_at
.所选日期来自date_select
.
我怎么能用ActiveRecord
来做呢?
我需要这样的东西:
"SELECT * FROM comments WHERE created_at BETWEEN '2010-02-03 00:00:00' AND '2010-02-03 23:59:59'"
我需要查询一天内的 comments .该字段是标准时间戳的一部分,为created_at
.所选日期来自date_select
.
我怎么能用ActiveRecord
来做呢?
我需要这样的东西:
"SELECT * FROM comments WHERE created_at BETWEEN '2010-02-03 00:00:00' AND '2010-02-03 23:59:59'"
请注意,目前公认的答案在Rails 3中已被弃用.你应该这样做:
Comment.where(:created_at => @selected_date.beginning_of_day..@selected_date.end_of_day)
或者,如果你想或必须使用pure string conditions,你可以:
Comment.where('created_at BETWEEN ? AND ?', @selected_date.beginning_of_day, @selected_date.end_of_day)