python获取oracle表结构_使用Python和cx-oracle从oracle以正确的格式获取日期字段

I am retrieving a load of data from one oracle database and then inserting it into another non linked database that is structurally the same.

I am doing it by doing:

select * from xxx where id = parameter

and

Select COLUMN_NAME from user_tab_columns where table_name=xxx

then with zip putting them in a dictionary as table_name:Data to build the insert from

Problem is it is returning the date fields as datetime.datetime(99, 12, 31, 0, 0). I need this as 31-dec-2999. How can I get it to return it like this or do I need to create a regex to do this?

I'm new to all this so if my method seems ridiculous feel free to say so and suggest a better method

Many thanks

Adam

解决方案

The cx_Oracle database adapter is giving you datetime.datetime() objects. Use methods on those objects to format them to a string if you require a different output.

The datetime.strftime() method would be best suited for your purposes:

dtobject.strftime('%d-%b-%Y')

Demo:

>>> import datetime

>>> dtobject = datetime.datetime(2999, 12, 31, 0, 0)

>>> dtobject.strftime('%d-%b-%Y')

'31-Dec-2999'

If, however, Oracle is really returning objects with the year set to 99 (not 2999) you need to repair the data:

if dtobject.year < 100:

dtobject = dtobject.replace(year=dtobject.year + 2900)