heroku Postgres error - operator does not exist timestamp without timezone = integer


Your parameters @monday and @friday are wrong, these have to be of type "timestamp without time zone" but are created as integers, see the errormessage. SQLite doesn't have any datetime-datatypes, so dates are stored as text or integers (unix-timestamps). This is why you don't get an errormessage in SQLite.

Make sure you create timestamps like '2004-10-19 10:23:54' and you will be fine. Another option could be the PostgreSQL-function to_timestamp() to convert your unix-timestamp to a timestamp:

@sent_emails = ContactEmail.all(:conditions => ['date_sent >= to_timestamp(?) and date_sent <= to_timestamp(?)', @monday, @friday])
Author by


Former electrical engineer but learning ruby from scratch thanks to stack overflow. Still so much to learn.

Updated on June 26, 2020


  • Satchel
    Satchel almost 3 years

    I am using the following code in my controller:

      @monday = (Time.now).at_beginning_of_week
      @friday = 5.days.since(@monday)-1.second
      @sent_emails = ContactEmail.all(:conditions => ['date_sent >= ? and date_sent <= ?', @monday, @friday])

    Although it works fine on my local sqlite, I have an "operator does not exist timestamp without timezone = integer" error.

    I'm not exactly clear what to change.