Join this group to access featured content and participate in discussions related to DMX.

149 Members
Join Us!

I have a task for transferring a table from Oracle to Vertica. This is done using pipes for intermediate data holder.While transferring other tables i do not get error. But When i transfer a table with a Timestamp data type column, the data in the particular column gets truncated and a default value of 1900-01-01 00:00:00 gets inserted.

The error is

invalid data found converting column CURTIME data to field value X'30342D4A554E2D31332030393A34343A33322E3030' at position 15 in record

I have used the TODATE function, still the issue persists.

Can anyone have anyidea how to transfer Timestamp data type records??

You need to be a member of Syncsort Community to add comments!

Join Syncsort Community

Email me when people reply –


  • Hi Merlin,

    It's been awhile since you posted this, so it's possible you've gotten past the problem.  If not, can you tell me what the exact error message is?  Would you be able to attach your task?




    Lisa Stanley

    DI Tech Support

This reply was deleted.

To access Syncsort Knowledge Base, visit:

My Support