June 07, 2004, 03:10 PM<westnt>
Convert DATE to DATETIME
How do you convert a DB2 date to an ORACLE datetime using ELT Manger 5.25
June 07, 2004, 04:29 PMJake Freivald
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')"