I'm trying to move a Netezza INTERVAL data type to Teradata.
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!