where condition created_at by date only rails

ammarvellous answered on December 13, 2022 Popularity 1/10 Helpfulness 1/10

answer where condition created_at by date only rails

where condition created_at by date only rails

Comment

# A simple trick is to use a BETWEEN clause, achievable without writing pure SQL and just by using ActiveRecord:
Count.where(created_at: Date.yesterday.beginning_of_day..Date.yesterday.end_of_day)

# It will translate to the following SQL:
WHERE ("counts"."created_at" BETWEEN '2019-01-02 00:00:00.000000' AND '2019-01-02 23:59:59.999999')

Popularity 1/10 Helpfulness 1/10 Language ruby

Source: stackoverflow.com

Tags: date ruby where

Link to this answer
Share Copy Link

Contributed on Dec 13 2022

ammarvellous

0 Answers Avg Quality 2/10

where condition created_at by date only rails

Contents

More Related Answers

where condition created_at by date only rails

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.