How to filter rails model by month

Question

I want to get only those records of my model which belong to a particular month. I am using:

Order.where(created_at.strftime("%B"): "April")

where created_at is DateTime. created_at.strftime("%B") gives me month, but it does not work. Any alternative?

score 1 · Answer 1 · answered May 10 '18 at 06:53

1

You'll probably have to do this in plan SQL (not the activerecord DSL):

Order.where("strftime('%m', created_at) = ?", 'April')

(I haven't done Rails in a while, let me know if this doesn't work)

answered May 10 '18 at 06:53

Will Richardson

You mean this - Order.where("strftime('%B', created_at) = ?", 'April'). Its not working – Umesh Malhotra May 10 '18 at 07:24
Order.where('extract(month from created_at)=?', 4) works but I want to search by month name not month number:- – Umesh Malhotra May 10 '18 at 07:29
It looks like [SQLite doesn't getting the month name](https://www.sqlite.org/lang_datefunc.html) so you will probably have to map it to a number yourself. – Will Richardson May 10 '18 at 10:38

1 Answers1