CSV From Oracle with timestamp column getting errors

From: "Saha, Sushanta K" <sushanta(dot)saha(at)verizonwireless(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: CSV From Oracle with timestamp column getting errors
Date: 2021-03-22 20:37:20
Message-ID: CAHty+vNygE5705DOE=AMk0uti=4MSbG61FErZFLMP-LJqvCW_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

\COPY table1 FROM '/tmp/Oracle_2020_06.csv' DELIMITER ',' CSV HEADER;
ERROR: invalid input syntax for type timestamp: "01-JUN-20 06.04.20.634000
AM"
CONTEXT: COPY table1, line 2, column last_update_timestamp: "01-JUN-20
06.04.20.634000 AM"

Appreciate any help with this psql command.

Thanks & Regards
.... Sushanta

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Saha, Sushanta K 2021-03-22 20:42:02 Re: CSV From Oracle with timestamp column getting errors
Previous Message Francisco Olarte 2021-03-22 19:04:05 Re: design partioning scheme for selecting from latest partition