AnsweredAssumed Answered

Javelin - timestamp issues

Question asked by LinoHerrera on Jun 7, 2017
Latest reply on Feb 14, 2018 by Francois.Calvert

Hi all. 

I'm using Javelin to execute a Bulk copy from a DB2 to an Oracle database. 

However it's facing an issue when it tries to copy a timestamp column. 

The format from DB2 is: 

   4/27/2017 15:15:59:728403

and Oracle is asking for this format: 

   27-APR-17 03.15.59.728403000 PM

 

When I execute the bulk copy process, the following message is appearing: 

   DATETIME/INTERVAL datatype conversion error

 

Is there any way to fix this issue using javelin? What would you suggest?

 

Thanks in advance. 

Outcomes