Rails ActiveRecord date between

Question

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

User · Answer

If you only want to get one day it would be easier this way   Comment all  conditions   gt    date created at        some date

User · Answer

there are several ways  You can use this method   start    selected date beginning of day end    selected date end of day  comments   Comment where  DATE created at  BETWEEN   AND     start  end    Or this    comments   Comment where  created at   gt   selected date beginning of day   selected date end of day

User · Answer

Just a note that the currently accepted answer is deprecated in Rails 3  You should do this instead   Comment where  created at   gt   selected date beginning of day   selected date end of day    Or  if you want to or have to use pure string conditions  you can do   Comment where  created at BETWEEN   AND      selected date beginning of day   selected date end of day

User · Answer

There should be a default active record behavior on this I reckon  Querying dates is hard  especially when timezones are involved   Anyway  I use     scope  between  - gt  start date nil  end date nil        if start date  amp  amp  end date       where    self table name  created at BETWEEN  start AND  end   start  start date beginning of day  end  end date end of day      elsif start date       where    self table name  created at  gt       start date beginning of day      elsif end date       where    self table name  created at  lt       end date end of day      else       all     end

User · Answer

Rails 5 1 introduced a new date helper method all day  see  https   github com rails rails pull 24930   gt  gt  Date today all day   gt  Wed  26 Jul 2017 00 00 00 UTC  00 00  Wed  26 Jul 2017 23 59 59 UTC  00 00   If you are using Rails 5 1  the query would look like    Comment where created at   selected date all day

User · Answer

This code should work for you   Comment find  all   conditions   gt    created at   gt   selected date beginning of day   selected date end of day     For more info have a look at Time calculations  Note  This code is deprecated  Use the code from the answer if you are using Rails 3 1 3 2

User · Answer

I ran this code to see if the checked answer worked  and had to try swapping around the dates to get it right  This worked--  Day where  reference date   gt  3 months ago  Time now  count    gt  721   If you re thinking the output should have been 36  consider this  Sir  how many days is 3 days to 3 people

User · Answer

I would personally created a scope to make it more readable and re-usable   In you Comment rb  you can define a scope   scope  created between  lambda   start date  end date  where  created at  gt     AND created at  lt       start date  end date      Then to query created between    comment created between 1 year ago  Time now    Hope it helps

User · Answer

I have been using the 3 dots  instead of 2   Three dots gives you a range that is open at the beginning and closed at the end  so if you do 2 queries for subsequent ranges  you can t get the same row back in both   2 2 2  003  gt  Comment where updated at  2 days ago beginning of day  1 day ago beginning of day  Comment Load  0 3ms   SELECT  comments    FROM  comments  WHERE   comments   updated at  BETWEEN  2015-07-12 00 00 00 000000  AND  2015-07-13 00 00 00 000000     gt    lt ActiveRecord  Relation    gt   2 2 2  004  gt  Comment where updated at  2 days ago beginning of day   1 day ago beginning of day  Comment Load  0 3ms   SELECT  comments    FROM  comments  WHERE   comments   updated at   gt    2015-07-12 00 00 00 000000  AND  comments   updated at   lt   2015-07-13 00 00 00 000000     gt    lt ActiveRecord  Relation    gt     And  yes  always nice to use a scope

User · Answer

You could use below gem to find the records between dates   This gem quite easy to use and more clear By star am using this gem and the API more clear and documentation also well explained    Post between times Time zone now - 3 hours     all posts in last 3 hours                   Time zone now    Here you could pass our field also Post by month  January   field   updated at   Please see the documentation and try it

User · Answer

Comment find  all   conditions   gt   date created at  BETWEEN   AND       2011-11-01   2011-11-15

[ruby-on-rails] Rails ActiveRecord date between

Examples related to ruby-on-rails

Examples related to rails-activerecord

Examples related to ruby-on-rails-2