Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#94 Some problems with date/time support

open
nobody
PgResult (5)
5
2006-07-31
2006-07-31
No

Since I am currently improving date/time support in
PyGreSQL, I had a quick look how you do it in PyPgSQL.
Particularly, I found no easy solution to handle the
cases when datestyle is set to 'sql,european' or
'postgres,european', since the output in this format
cannot be distinguished from the US variant. I saw that
PyPgSQL cannot handle this case either. Probably we can
only add this as a caveat to the documentation of the
modules.

I also observed the following minor problems with PyPgSQL :

- ValueError for intervals with microseconds
- negative dates (years BC) are not handled correctly
- timestamps outside the Unix epoch are not handled
correctly

Discussion