select posts from one day

Question

I want to select posts from one day. What is the correct way? This errors:

date = '3/11/2016'.to_date

User.joins(:posts).where(posts: {'created_at >= ? AND created_at <= ?', date.beginning_of_day, date.end_of_day})

`User.joins(:posts).where('posts.created_at >= ? AND posts.created_at <= ?', date.beginning_of_day, date.end_of_day)` — gabrielhilal, Nov 03 '16 at 14:41

score 1 · Accepted Answer · answered Nov 03 '16 at 14:30

1

Posts.where('created_at >= ? and created_at <= ?', Date.today.at_beginning_of_month, Date.today)

There is no need to join User unless you want the user as well then you could do this

User.joins(:posts).all.where('posts.created_at >= ? and posts.created_at <= ?', Date.today.at_beginning_of_month, Date.today).preload(:posts)

The preload will help with efficiency

answered Nov 03 '16 at 14:30

C dot StrifeVII

score 0 · Answer 2 · answered Nov 03 '16 at 14:27

0

If you are just trying to select by day you might try something like this.

User.joins(:posts).where(posts: { 'extract(day from created_at) = ?', desired_day_of_month } )

answered Nov 03 '16 at 14:27

Dan

Maybe something along these lines then `'2016-11-03'.to_date.day` – Dan Nov 03 '16 at 14:34

score 0 · Answer 3 · answered Nov 03 '16 at 14:37

you have an issue with the syntax:

posts: {'created_at >= ? AND created_at <= ?', date.beginning_of_day, date.end_of_day}

the hash syntax should be used to send the columns to query, such as:

posts: { title: 'some title' }, etc

In your case, you should do:

User.joins(:posts).where('posts.created_at >= ? AND posts.created_at <= ?', date.beginning_of_day, date.end_of_day)

3 Answers3