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.s...@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*