Postgres Pro
Downloads
Home   >   mailing lists

Re: CSV From Oracle with timestamp column getting errors - Mailing list pgsql-general

From Saha, Sushanta K
Subject Re: CSV From Oracle with timestamp column getting errors
Date
Msg-id CAHty+vPDYMu48MyuJd8+BnuKkehT5aYyFVra6_+wmssa-HJ2-A@mail.gmail.com
Whole thread Raw
In response to CSV From Oracle with timestamp column getting errors  ("Saha, Sushanta K" <sushanta.saha@verizonwireless.com>)
List pgsql-general
Tree view
The table column definition:

          Column           |              Type              |
---------------------------+--------------------------------+
 last_update_timestamp     | timestamp(6) without time zone |

Thanks & Regards
.... Sushanta


On Mon, Mar 22, 2021 at 4:37 PM Saha, Sushanta K <sushanta.saha@verizonwireless.com> wrote:
\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



--

Sushanta Saha|MTS IV-Cslt-Sys Engrg|WebIaaS_DB Group|HQ - VerizonWireless
O 770.797.1260  C 770.714.6555 Iaas Support Line 949-286-8810

pgsql-general by date:

Previous
From: "Saha, Sushanta K"
Date:
Subject: CSV From Oracle with timestamp column getting errors
Next
From: Victor Yegorov
Date:
Subject: Re: CSV From Oracle with timestamp column getting errors