Re: odbc DbiDate date conversion

2006-09-27 Thread flupke
Frank Millman schreef: > Not that I know of. The results of my investigations so far seem to > indicate that we have a problem :-( > > Here is a link to an article dated 1998 - > https://svn.python.org/www/trunk/pydotorg/windows/OdbcHints.html > > Among other interesting stuff, it states -

Re: odbc DbiDate date conversion

2006-09-27 Thread Frank Millman
flupke wrote: > Frank Millman schreef: > > > > Well waddyaknow - I get exactly the same, for dates earlier than > > 1970-01-02. Thanks for finding a bug that would have bitten me sooner > > or later. > > > > I will do some investigation. If I find an answer I will post it here, > > unless some ki

Re: odbc DbiDate date conversion

2006-09-26 Thread flupke
flupke schreef: When i do the same sql from a client, i get this: 1961-02-15 Seems ok. If i check the catalog, the native field type is listed as 10 positions and of type date. Yet when i print it after i got the values i get this which looks very weird (print "value ",str(i)," type ",type(i)):

Re: odbc DbiDate date conversion

2006-09-26 Thread flupke
Frank Millman schreef: > Well waddyaknow - I get exactly the same, for dates earlier than > 1970-01-02. Thanks for finding a bug that would have bitten me sooner > or later. > > I will do some investigation. If I find an answer I will post it here, > unless some kind soul saves me the trouble an

Re: odbc DbiDate date conversion

2006-09-26 Thread Frank Millman
flupke wrote: > Frank Millman schreef: > > flupke wrote: > >> I'm using a solid DB and i'm accessing it via the odbc module > >> (activepython). > >> I get a DbiDate object returned but i don't find a way to decently print > >> it or get a format like %d/%m%/%y. > >> > > > > I convert it to a date

Re: odbc DbiDate date conversion

2006-09-26 Thread flupke
Frank Millman schreef: > flupke wrote: >> I'm using a solid DB and i'm accessing it via the odbc module >> (activepython). >> I get a DbiDate object returned but i don't find a way to decently print >> it or get a format like %d/%m%/%y. >> > > I convert it to a datetime() instance, like this - >

Re: odbc DbiDate date conversion

2006-09-26 Thread Frank Millman
flupke wrote: > I'm using a solid DB and i'm accessing it via the odbc module > (activepython). > I get a DbiDate object returned but i don't find a way to decently print > it or get a format like %d/%m%/%y. > I convert it to a datetime() instance, like this - mydate = datetime.datetime.from

odbc DbiDate date conversion

2006-09-26 Thread flupke
I'm using a solid DB and i'm accessing it via the odbc module (activepython). I get a DbiDate object returned but i don't find a way to decently print it or get a format like %d/%m%/%y. I found a few posts but the code doesn't work. >>> birthd = results[0][4] #info from db >>> birthd >>> str(birt