I'm confused as to what's going on with a PostgreSQL "timestamp" type
converted back to string. The field in question is a "timestamp without
Selecting my timestamp from PostgreSQL via psql gives:
Yet in my code, when I str() or mx.DateTime.ISO.strUTC() the mx.DateTime
representation of the field returned by pyPgSQL, I get
I'm currently in UTC+11 (10+summer)
Any suggestions as to what might be happening here?
When I first connect to PostgreSQL, I always SET TIME ZONE 'UTC'.
PS> Cross-posted to the Egenix mailing list