Re: [Pypgsql-users] Using and manipulating dates

[Karsten H. <Kar...@gm...>]

Godoy,

dates are returned as mx.DateTime.DateTime instances. That
package (eGenix mx) provides for quite nice data manipulation.
You can look up their docs at their website.

One never changes the format a date is *stored* in the
database, only the way it is *presented to* the database for
storage. I usually send ISO dates to the database and convert
to any format I desire from the mx DateTime instances I get
back.

Note that *interval* support is broken in pyPgSQL if you use
age() in your selects. I posted a patch a few weeks back but
there seemed to be no interest.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346