How to find records created this month in Rails 3.1?

Question

Anyone know the best query to find records created THIS month in Rails 3.1?

Answer 1

class Model
  scope :this_month, -> { where(created_at: Time.now.beginning_of_month..Time.now.end_of_month) }
end

you can call it like this:

Model.this_month

Answer 2

I prefer SQL-less:

Model.where(:created_at => Time.now.beginning_of_month..Time.now.end_of_month)

or as a scope:

class Model < ActiveRecord::Base
  scope :this_month, -> { where(:created_at => Time.now.beginning_of_month..Time.now.end_of_month) }
end