Best way to move Netezza Interval to Teradata?

Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.

Best way to move Netezza Interval to Teradata?

I'm trying to move a Netezza INTERVAL data type to Teradata.


Netezza Intervals

Teradata Intervals


I can convert all INTERVALS to seconds, but I don't think I can use this to INSERT into any kind of Teradata INTERVAL.


Currently, we're casting all INTERVALS as VARCHAR(50) and moving the data to a VARCHAR(50) column on Teradata.


Does anyone have any experience with this and is there any "best practice" to move Netezza INTERVALS to Teradata?


I'm using TPT.  Thanks!