[cx-oracle-users] Timestamp datatype doesn't display fractions of a second

[Chris D. <cdu...@ya...>]

Hi,

I'm unable to get cx_Oracle to fully display an Oracle 9i Timestamp column:

>>> cur = db.cursor()
>>> cur.execute("select order_date from oe.orders where rownum < 2")
[<TimestampVar object at 0x007EB260>]
>>> print cur.description
[('ORDER_DATE', <type 'TimestampVar'>, -1, 11, 0, 0, 0)]
>>> data = cur.fetchall()
>>> print data[0][0]
1999-08-16 22:34:12
>>> type(data[0][0])
<type 'ExternalDateTimeVar'>

As you can see the fractions of second aren't being displayed.

Maybe there's a clue in that the column is actually being returned into an ExternalDateTimeVar
type not a TimestampVar defined by the cursor. This could easily be me jumping to conclusions.

I'm running 4.0.1 on a 9.2 client on Windows against a 9.2.0.4 database on Linux.

Thanks,

Chris Dunscombe

Reg



		
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail