[DB-SIG] adodbapi return datetime

2009-02-10 Thread William Dode
Hi, How should i do to make adodbapi return datetime instead of mx.DateTime? I tried import adodbapi adodbapi.dateconverter = adodbapi.pythonDateTimeConverter() Maybe i didn't test well, but it doesn't seems to work... thanks -- William Dodé - http://flibuste.net Informaticien Indépendant _

Re: [DB-SIG] adodbapi return datetime

2009-02-10 Thread Vernon Cole
William: It has always seemed to me that the syntax you tried should work. Perhaps someday, some "real" Python guru will explain to me why sometimes it does not, and maybe even tell me how to fix it. Perhaps the module definition is not done quite right, I dunno? Try adding an extra level of depth

Re: [DB-SIG] adodbapi return datetime

2009-02-10 Thread William Dode
On 10-02-2009, Vernon Cole wrote: > William: > It has always seemed to me that the syntax you tried should work. Perhaps > someday, some "real" Python guru will explain to me why sometimes it does > not, and maybe even tell me how to fix it. Perhaps the module definition is > not done quite right,

Re: [DB-SIG] adodbapi return datetime

2009-02-10 Thread Vernon Cole
This is a poll: Should adodbapi be changed so that datetime.datetime is the default return type for SQL date-time columns? (The present implementation will default to mx.DateTime if present.) My feeling is "yes", because 1) the Python 3.0 version of pywin32 will return COM date-times as datetim

Re: [DB-SIG] adodbapi return datetime

2009-02-10 Thread Robert Brewer
Vernon Cole wrote: > Should adodbapi be changed so that datetime.datetime is > the default return type for SQL date-time columns? Almost certainly at the next major version. That's the easy part. Now the hard part: get the community to design, build, and release the next major version. You have my

Re: [DB-SIG] adodbapi return datetime

2009-02-10 Thread William Dode
On 10-02-2009, Robert Brewer wrote: > Vernon Cole wrote: >> Should adodbapi be changed so that datetime.datetime is >> the default return type for SQL date-time columns? > > Almost certainly at the next major version. For me the weird problem of a different behaviour if mx is installed or not is

Re: [DB-SIG] adodbapi return datetime

2009-02-10 Thread M.-A. Lemburg
On 2009-02-10 18:42, William Dode wrote: > On 10-02-2009, Robert Brewer wrote: >> Vernon Cole wrote: >>> Should adodbapi be changed so that datetime.datetime is >>> the default return type for SQL date-time columns? >> Almost certainly at the next major version. It's probably better to make this a

[DB-SIG] PostgreSQL Conference East looking for speakers.

2009-02-10 Thread Joshua D. Drake
PostgreSQL Conference East is being held at historic Drexel University on April 3rd through 5th 2009 . This is a community conference and the proceeds benefit United States PostgreSQL. This is the second call for papers. The call for papers ends Feb 23rd and speakers will be notified on the 27th.

Re: [DB-SIG] adodbapi return datetime

2009-02-10 Thread William Dode
On 10-02-2009, M.-A. Lemburg wrote: > On 2009-02-10 18:42, William Dode wrote: >> On 10-02-2009, Robert Brewer wrote: >>> Vernon Cole wrote: Should adodbapi be changed so that datetime.datetime is the default return type for SQL date-time columns? >>> Almost certainly at the next major ve

[DB-SIG] py<--->sqlserver

2009-02-10 Thread wtr_web
Hello! I want to thank all of you who have sent me lots of valuable information! I felt even a bit overwhelmed... I have to check/test, what is best suited for this one-time task of moving/combining data from several databases into a new joint structure. The "real" programming will be done w