How do I specify this `WHERE` condition without using SQL?

Question

I'm using the following raw Postgres SQL in my where() call to find records where some_date is two days from now:

SomeModel.where('date(some_date) - date(NOW()) = 2')

Can it be written using pure ActiveRecord syntax without raw SQL?

Eyeslandic · Accepted Answer · 2017-03-20 23:00:20Z

2

This should work, haven't tested it though.

SomeModel.where('date(some_date) = ?', 2.days.ago.to_date)
#or
SomeModel.where('some_date::date = ?', 2.days.ago.to_date)

If you want it to be any purer, without the date sql function, I'm not seeing it, at least not without creating a db view.

answered Mar 20, 2017 at 22:46

Eyeslandic

14.9k13 gold badges44 silver badges55 bronze badges

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

2 Comments

Unfortunately this doesn't work with the version of where() that takes a hash. :(

It would be nice but I can live without it. Unless you know an easy way...