Extracting time from timestamp to insert

Tools
Highlighted
akp
N/A

Extracting time from timestamp to insert

Hello members/readers,

This is with reference to unloading data from DB2 and loading the same to Teradata.
I have a flat file file in which timestamp is unloaded but i want to insert date and time separately in Teradata using MLOAD Insert.
How can we achieve this?
I have seen some examples where "Extract" or "Cast" function is used in SELECT clause.
My requirement is to INSERT and not SELECT?

Plz help.
1 REPLY
Enthusiast

Re: Extracting time from timestamp to insert

You can use CAST and EXTRACT on any expression, not only columns values...