Equivalent of strftime in Postgres

postgresql, ruby-on-rails, ruby-on-rails-4

Solution

Looks like it is a great time to start learning SQL! Made my method work using the following code:

  def self.query_by_year_month(y, m)
    where("extract(year from date) = ? and extract(month from date) = ?", y, m)
  end

Problem

After migrating my SQLite database to Postgres on the development server, I get the ``` PG::UndefinedFunction: ERROR: function strftime(unknown, date) does not exist ``` Is there a function I could use to keep the functionality across my app? Edit: tried using to_char but failed miserably. In particular, I do not understand how to implement it in a construction such as ``` def self.query_by_year_month(y, m) where("strftime('%Y', date) = ? and strftime('%m', date) = ?", y, m) end ``` Thank you!

Original source