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

24,962

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])
Share:
24,962
Satchel
Author by

Satchel

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

Updated on June 26, 2020

Comments

  • Satchel
    Satchel about 2 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.

    Ideas?

    Thanks.