[DB-SIG] WHat's the status of DB modules and datetime.py support?

[M.-A. Lemburg]

Simon Willison wrote:
> We're trying to find a Python DB module for Postgres that includes 
> native support for 2.3's datetime.py date types - so dates come out of 
> the database as datetime objects and datetime objects are converted to 
> postgres date times on insert/update transparently.
> 
> We haven't found one yet. Is there any movement within the Python DB 
> community towards 2.3's datetime.py? It seems like a great way of 
> dealing with dates, but the current batch of DB modules all appear to 
> use their own convention. Is this something that the DB API standard 
> should cover?

The standard already supports date/time values and how they can
be passed to the database modules. Most DB modules use the mxDateTime
extension to deal with this.

> Any tips on how to best deal with the transfer of dates from Python to 
> Postgres and back again would be welcome.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Dec 30 2003)
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::