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