Q:

Import CSV to teradata sql Assistant (TD 14) Date error

I created a table with column : open_dt DATE FORMAT 'DD-MMM-YY' and am inserting records from a delimited txt file with records (28-Dec-94 , 1-Nov-80, 7-feb-06 ....etc). I get "Error executing query for record 2 : 2666: Invalid date supplied for open_dt". 
Can someone help me with this. Thanks

A:

Teradata doesn't support a single digit day.
You got luck, TD14 implements Oracle's TO_DATE which allows it:
to_date(input_string, 'dd-mon-yy')

But '28-Dec-94' might return '28-Dec-2094' instead of '28-Dec-1994'.

