|
Go
![]() |
New
![]() |
Search
![]() |
Notify
![]() |
Tools
![]() |
Reply
![]() |
|
|
Member |
How do you convert a DB2 date to an ORACLE datetime using ELT Manger 5.25
|
||
|
|
Member |
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 |
|||
|
| Previous Topic | Next Topic | powered by eve community |
| Please Wait. Your request is being processed... |
|

