[PyGreSQL] pygresql - timestamp handling

James Laska jal233 at gmail.com
Wed Nov 16 12:07:41 EST 2005


Greetings,

I'm attempting to find out the reason for using a string when
representing a DATETIME column.  I was expecting a DateTime object to
be returned so that date operations could be performed on that column.
 I've found several references in the list archives that indicate this
is intentional.

[ http://mailman.vex.net/mailman/htdig/pygresql/2005-August/001490.html ]
 > > when querying a timestamp, i always get a string object (rather than
 > > datetime.datetime | mx.DateTime.DateTime). Is this intended?
 > I think this is by intent.

[ http://mailman.vex.net/mailman/htdig/pygresql/2004-June/001320.html ]
references a make pgdb.pgdbTypeCache return objects of type DateTime

Is this supposed to shift any date parsing to the SQL side of things? 
My apologies if this topic has already been addressed.  Would someone
mind pointing me in the right direction?

Many thanks,
James Laska


More information about the PyGreSQL mailing list