odbc DbiDate date conversion

flupke flupke at nonexistingdomain.com
Tue Sep 26 10:42:39 EDT 2006


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 -
> 
>     mydate = datetime.datetime.fromtimestamp(int(dbidate))
> 
> Then I can use all the functionality of the datetime module.
> 
> HTH
> 
> Frank Millman
> 

Hi Frank,

i tried it and i end up with this:

>>> mydate = datetime.datetime.fromtimestamp(int(birthd))
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
ValueError: timestamp out of range for platform localtime()/gmtime()
function

Regards,
Benedict



More information about the Python-list mailing list