On Wed, Feb 22, 2012 at 8:34 AM, Iain Barnett <[email protected]> wrote: > I've recently moved an app to Heroku, using one of their Postgres databases. > The times coming out of that database were -8 hrs, so I started having a > look and it seems the times were being saved with the timezone even though > the column type is "timestamp without time zone". > > It also appears that the database timezone is set to localtime, which means > its localtime of -8hrs to UTC, that I can't change that, and that Sequel > believes those times to be UTC so I'm getting the wrong times in my app. > >
Take a look at SET TIME ZONE. We're aware of the problem, and the new shared databases in beta today shouldn't have it. http://www.postgresql.org/docs/8.1/static/sql-set.html -- Peter van Hardenberg San Francisco, California "Everything was beautiful, and nothing hurt." -- Kurt Vonnegut -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
