轨道之间的ActiveRecord日期 [英] Rails ActiveRecord date between
本文介绍了轨道之间的ActiveRecord日期的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要查询在一天提出的意见。本场是标准时间戳的一部分,是created_at。选定的日期是从date_select到来。我如何使用ActiveRecord来做到这一点?
我需要财产以后这样的:
SELECT * FROM评论WHERE created_at'之间2010-02-03 00:00:00和23:59:59 2010-02-03'
解决方案
只是说明了目前公认的答案是德precated用Rails 3。你应该这样做,而不是:
Comment.where(:created_at => @ selected_date.beginning_of_day .. @ selected_date.end_of_day)
I need to query comments made in one day. The field is part of the standard timestamps, is created_at. The selected date is coming from a date_select. How can I use ActiveRecord to do that?
I need somthing like:
"SELECT * FROM comments WHERE created_at BETWEEN '2010-02-03 00:00:00' AND '2010-02-03 23:59:59'"
解决方案
Just a note that the currently accepted answer is deprecated in Rails 3. You should do this instead:
Comment.where(:created_at => @selected_date.beginning_of_day..@selected_date.end_of_day)
这篇关于轨道之间的ActiveRecord日期的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文