SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insert db2 timestamp into oracle timestamp

CrazeFeb 18 2009 — edited Feb 19 2009

Hi All,

Is there any method to extract timestamp data from DB2 and insert into Oracle table. In oracle, when I select the field from DB2 thru DBlinks, the END_TIME will remove the microsecond. I need to extract the actual time with micro second in Oracle and store the value. Please advise.

Select in DB2
END_TIME : 2009-02-18 16:59:14.963000

Select in Oracle from DB2 through DBLinks.
END_TIME : 2009-02-18 16:59:14

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 19 2009

Added on Feb 18 2009

12 comments

3,271 views