0

I have a .txt file contains timestamp column like 9/1/2020 00:00:00.000000 and some other columns.but while importing into teradata SQL assistant getting invalid time stamp error. please help me the way as I need to import file data into volatile and has to do minus operation between these file table and actual table.

and the column datatype define in teradata table is timestamp(6)

Milan chaudhary
  • 3
  • 4
  • How are you attempting to import the data? Show at least the code for the timestamp column. – Andrew Apr 08 '21 at 14:02
  • 2
    Single-digit month and day will be an issue. Either change the source text format or use a RegEx to ensure 2-digit values, then specify that format in a `CAST` or `TO_TIMESTAMP`. See https://stackoverflow.com/questions/57635651 – Fred Apr 08 '21 at 14:32

0 Answers0