All Forums Tools
akp 1 post Joined 12/07
20 Dec 2007
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.

al1_24 39 posts Joined 11/04
21 Dec 2007

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

You must sign in to leave a comment.