Focal Point
Convert DATE to DATETIME

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/6341087331

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 PM
Jake 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')"

Regards,
Jake