TDLOAD Utility - Input DATE and TIME STAMP format issue

Tools

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

Tags (3)
1 REPLY
Teradata Employee

Re: TDLOAD Utility - Input DATE and TIME STAMP format issue

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