CODEWITHSUNDEEP
teradata
TD123
TD123

Reputation: 27

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

Upvotes: 0

Views: 3629

Answers (1)

dnoeth
dnoeth

Reputation: 60462

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

Upvotes: 1

Related Questions