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

[M.-A. Lemburg]

Guido van Rossum 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?
> 
> I guess 2.3 hasn't been out long enough to get the various db api
> authors to make the switch.  Perhaps a DB-API standard update should
> be issued (e.g. DB-API 2.1) that requires using this for Python 2.3?

No, that would not be in the spirit of the DB-API standard.

The spec already includes a reference the datetime module,
but in its current state it's not too useful for C extensions:

	http://www.python.org/peps/pep-0249.html

-- 
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 ! ::::