Rails Postgres Time Zone Handling

The simple thing I want is to store a DateTime in UTC in the database and retrieve it in UTC again, but rails seems to assume I stored the DateTime in my local time zone and adds the 8 hours difference (PST). I have a DateTime field in my model. If I send a request (PUT) to update this field in a particular instance of my model, somehow timezones get mixed up for whatever reason: Sending to rails via PUT: 2012-02-17T03:46:58Z Returned via subsequent GET: 2012-02-17T11:46:58Z The time difference is exactly 8 hours and could be explained by my timezone which is PST (-08:00). I am using Datamapper 1.2 on Rails 3.1.3. I set my application config timezone to UTC explicitly. I also tried to use dm-zone-types. Did not change anything for me. A git-bisect on my repo revealed, that this misbehavior was introduced as I switched the database to postgres from the original sqlite. This commit only changed the database.yml and the gemfile. Nothing else. Any ideas?
Take Your Experience to the Next Level
NewDownload our mobile app for a faster and better experience.
Comments
0U
Join the discussion
Sign in to leave a comment