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
Err insert timestamp value (with Microseconds) into Oracle9i
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 5
- Joined: Mon Sep 20, 2004 6:41 am
- Location: Singapore
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.
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.