How do you convert a DB2 date to an ORACLE datetime using ELT Manger 5.25
From one of the product managers:
"ORACLE doesn't have a datetime format, it just has DATE which can contain a DATE, a TIME or BOTH.
"If the ORACLE DATE column is described as YYMD, DATE you can just assign the DB2 DATE. If it's described as HYYMDS,HYYMDS then use a load transform of HDTTM(DAT, 8, 'HYYMDS')"
|Powered by Social Strata|