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 something like:
"SELECT * FROM comments WHERE created_at BETWEEN '2010-02-03 00:00:00' AND '2010-02-03 23:59:59'"