Import csv with datetime column in postgresql

  Kiến thức lập trình

I am trying to import a CSV in postgres which has one column with datetime2(7) type.
Getting error as below

1. ERROR:  invalid input syntax for type timestamp: "CREATE_S"
2. CONTEXT:  COPY table_s, line 1, column CREATE_S: "CREATE_S"

What should be done to pass the datetime field.

So far, I tried to make the datetime field as character varying and imported sucessfully.
But, now I am unable to alter the column back to timestamp. Error

ERROR:  invalid input syntax for type timestamp: "CREATE_S"
SQL state: 22007

Any help is appreacited. Thanks in advance

LEAVE A COMMENT