Unable to import data from notepad or csv file

General
Enthusiast

Unable to import data from notepad or csv file

Hi Folks,

I am trying to import data into newly created table from notepad. I am getting the below error while importing the same.

Error executing query : 2666 Invalid dates  supplied for _inst_date column 

while creating table  I am creating date columns with data type Date format 'dd/mm/yyyy' 

Please help me to resolve this issue.

Thanks,

raghu

4 REPLIES
Enthusiast

Re: Unable to import data from notepad or csv file

You using any Teradata utilities or importing from SQL Assistant directly?

Enthusiast

Re: Unable to import data from notepad or csv file

while loading, in most cases, Teradata utilities require data as it is defined in table structure.

Please check data type for your column from table which is having problem. if its yyyy-mm-dd, try using exactly same format.

Fan

Re: Unable to import data from notepad or csv file

As you have data type defined in format: 'dd/mm/yyyy'  make sure in your data file also you have same format.

Teradata Employee

Re: Unable to import data from notepad or csv file

If the data format is not as per the DDL format, you can load the dates in table as VARCHAR and then CAST them to date.