how to filter record use date only in rails & postgres

Question

I have some data like

id   post  created_at
1     test  timestamp 
2     hello  timestamp 
3     test  timestamp

i use rails, postgres

Ben Trewern · Accepted Answer · 2020-06-14 00:59:13Z

1

Try the following:

Post.where("date(created_at) = ?", Date.parse('2020-06-14'))

and

Post.where("date_trunc('hour', created_at) = ?", Time.parse('2020-06-14 11:00'))

answered Jun 14, 2020 at 0:59

Ben Trewern

1,7401 gold badge11 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1