All Forums Tools
13 Jan 2016
TDLOAD Utility - Input DATE and TIME STAMP format issue

Hi,
We are using TDLOAD mechanism to load Staging Layer from File. I belive the default DATE and Timestamp format in the input file which has been configured in DBS Utility would be accepted only. e.g. YYYY-MM-DD.
Is there any functionality/option in the TDLOAD mechanism to accept custom DATE and TIMESTAMP format specified in the Run Time?
Regards....Sanjoy

Regards....Sanjoy
feinholz 1234 posts Joined 05/08
13 Jan 2016

tdload does not support that functionality (yet) from a global standpoint.
Until we add that feature, you will have to write a TPT script and use the FORMATIN/FORMATOUT syntax in the schema to have TPT convert your Date/Timestamp data from its original format to the format expected by Teradata.
 

--SteveF

You must sign in to leave a comment.