Get all records created today in Rails

Question

I want to get all the records from the database which are create_at today. But when I do

Model.where('DATE(created_at) = ?',Date.today)

it returns only the last record that is created today. I have 3 records with created_at

2015-03-03 11:38:31
2015-03-03 11:59:00
2015-03-03 11:33:04

. But it returns only the record with '2015-03-03 11:38:31' this created_at date.

 Model.where("DATE(created_at) = ?",Date.today)

and

 Tracking::TrackingLogin.where("created_at >= ?", Time.zone.now.beginning_of_day)

Please someone explain what is happening in my code?

`Model.where("created_at >= ?", Time.zone.now.beginning_of_day)` — Sonalkumar sute, Mar 03 '15 at 12:08
if you are using `mysql` `Model.where("DATE(created_at) = ?", Date.today)` this should also work — Sonalkumar sute, Mar 03 '15 at 12:11
Check what you get when you print `DATE(created_at)` and `Date.today` their format and does it trying to match exact time when you are doing `Model.where("DATE(created_at) = ?",Date.today)`. Try putting hardcoded timestamps `2015-03-03 11:59:00` and see if it returns the record. — Sonalkumar sute, Mar 03 '15 at 12:52

score 12 · Answer 1 · edited Mar 03 '15 at 14:22

12

Try the following:

Model.where("created_at >= ?", Time.zone.now.beginning_of_day)

edited Mar 03 '15 at 14:22

kenorb

answered Mar 03 '15 at 12:15

user3118220

score 0 · Answer 2 · answered Sep 12 '22 at 09:49

0

Model.where("created_at >= ?", Time.zone.now.beginning_of_day)

Model = your model name

(i.e,. User.where("created_at >= ?", Time.zone.now.beginning_of_day))

answered Sep 12 '22 at 09:49

bansalsb57

1

This answer could use some clarity and formatting – user16217248 Sep 17 '22 at 02:33
[Formatting help](https://stackoverflow.com/editing-help). – Y. E. Sep 18 '22 at 16:04

score -1 · Answer 3 · answered Mar 03 '15 at 12:18

-1

Model.where("created_at >= ?", Date.today)

answered Mar 03 '15 at 12:18

yms9654

This also returns only the first record. Not all the records. – Suganya Mar 03 '15 at 12:21
this isn't right. Date.today comes without timezone information, sql plan will looks like => SELECT "modes".* FROM "modes" WHERE "modes"."is_deleted" = 'f' AND (created_at >= '2016-05-17') which is queried by UTC of today. – catsky May 17 '16 at 03:53

3 Answers3