Err insert timestamp value (with Microseconds) into Oracle9i

ksenthilvel · Post by **ksenthilvel** » Fri Dec 10, 2004 6:17 am

HI,
I need to insert timestamp value (Including microseconds) to Oracle9i DB. The timestamp value to be extracted from DB2. When I try to insert the timestamp value into Oracle table it is accepting only date and time value. The microsecond value is dropped even though I have declared timestamp data type in oracle.

Please advice how to insert timestamp value (with Microseconds) into Oracle9i.
We are using datastage DSEE7.5.01 PX

Regards,
Senthilvel.k

T42 · Post by **T42** » Mon Dec 13, 2004 5:35 pm

Did you also include the Microsecond extended option? It's the column next to the type (where you declared Timestamp). It's usually blank, but can be set to include Microseconds.

mandyli · Post by **mandyli** » Tue Dec 14, 2004 10:18 pm

good senthil..

T42 · Post by **T42** » Sun Dec 19, 2004 12:18 pm

It would definitely be very helpful if you would submit this as an enhancement request to Ascential Support to ensure that Ascential will be aware of this problem with Oracle and microseconds.

That's the only way they will be sure to include it in the next version (if it have not already been provided in 7.5a or 7.5x2.