mxDateTime on pyPgSQL/PostgreSQL applies timezone?

Kingsley Turner <kingsley.turner-jEoFCcbHCOSJLVpJL2nGXleTHsez0gnBQQ4Iyu8u01E@public.gmane.org> Thu, 13 Jan 2011 09:15:51 +1100

Newsgroups	gmane.comp.python.egenix.user
Message-ID	<[email protected]>

Hi,

I'm confused as to what's going on with a PostgreSQL "timestamp" type 
converted back to string.

Selecting my timestamp field from PostgreSQL via psql gives:

    2011-01-12 21:54:11


Yet in my code, when I str() or mx.DateTime.ISO.strUTC() the mx.DateTime 
representation of the field returned by pyPgSQL, I get

    2011-01-13 08:01:04.00
    2011-01-13 08:54:11+0000


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 TIMEZONE UTC.

cheers,
-Kingsley


_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users