Insert db2 timestamp into oracle timestamp
CrazeFeb 18 2009 — edited Feb 19 2009Hi 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