pypgsql-users

[Pypgsql-users] Using and manipulating dates

[Jorge G. <go...@ie...>]

Hi!


How do you usually handle dates? What module(s) do you use for manipulating
and showing dates in, e.g., european format? do you change the way date is
stored in the database or you store it in ISO format and convert to and
from the frontend application?

-- 
Godoy.      <go...@ie...>

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