Re: CSV From Oracle with timestamp column getting errors

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(dot)saha(at)verizonwireless(dot)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*