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.
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.
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.