Postgres Pro
Downloads
Home   >   mailing lists

Re: COPY and custom datestyles. Or some other technique? - Mailing list pgsql-general

From David G. Johnston
Subject Re: COPY and custom datestyles. Or some other technique?
Date
Msg-id CAKFQuwaTsyxzm_tvB=VgYsNVENKY+Nsu=TpWx1OABCJc8zibmA@mail.gmail.com
Whole thread Raw
In response to Re: COPY and custom datestyles. Or some other technique?  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view
On Wed, Mar 29, 2023 at 7:39 PM Ron <ronljohnsonjr@gmail.com> wrote:
Something like this?

ALTER TABLE foo
    ALTER COLUMN update_ts TIMESTAMP WITHOUT TIME ZONE
        USING to_timestamp(update_ts, 'YYYYMMDDHH24miSSMS');

That would definitely minimize the possibility of errors.

Yes.

David J.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: COPY and custom datestyles. Or some other technique?
Next
From: Vladimir Sitnikov
Date:
Subject: Re: Do BRIN indexes support MIN/MAX?