IB - Developer Center    Forums  Hop To Forum Categories  iWay Products    Convert DATE to DATETIME
Go
New
Search
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Member
Posted
How do you convert a DB2 date to an ORACLE datetime using ELT Manger 5.25
 
Posts: 1 | Registered: May 23, 2004Reply With QuoteEdit or Delete MessageReport 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 QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

IB - Developer Center    Forums  Hop To Forum Categories  iWay Products    Convert DATE to DATETIME

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