Horton
Menu

CSV From Oracle with timestamp column getting errors

Saha, Sushanta K <sushanta.saha@verizonwireless.com>

View thread
From: "Saha, Sushanta K" <sushanta.saha@verizonwireless.com>
To: pgsql-general@postgresql.org
Date: 2021-03-22T20:37:20Z
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