[EMAIL PROTECTED] wrote:
> Been using the ODBC module for Python 2.1 (Win32) and had another
> question. When I return data from date columns, it's in a strange
> object form, e.g. <something or other> (don't have the output in front
> of me>.
>
> What's an easy way to convert date objects into a human-readable
> string? I'm using this module to extract data from an Oracle database,
> then converting it to a flat-file for import into an old flat-file
> database on a mainframe. I need to be able to change the date object
> into something the mainframe database will recognize.
>
odbc returns something called a DbiDate object.
You can convert this into a datetime object like this -
import datetime
dat = datetime.datetime.fromtimestamp(int(dbidate_object))
Now you can use any of the datetime attributes or methods to convert it
to human-readable form, such as dat.year, dat.month, str(dat), etc
I use odbc with MS Sql Server. I have never used Oracle, so I can't be
sure that it works the same way. Try it and see what happens.
HTH
Frank Millman
--
http://mail.python.org/mailman/listinfo/python-list
