Skip to Main Content

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2009
Added on Feb 18 2009
12 comments
3,271 views