Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Convert DATE to DATETIME
Go
New
Search
Notify
Tools
Reply
  
Convert DATE to DATETIME
 Login/Join
 
<westnt>
posted
How do you convert a DB2 date to an ORACLE datetime using ELT Manger 5.25
 
Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 20 | Location: NY, NY | Registered: June 19, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Convert DATE to DATETIME

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.