date format

From: Marc Millas <marc(dot)millas(at)mokadb(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: date format
Date: 2023-06-14 16:42:38
Message-ID: CADX_1aafydAJ6RA=nGUkYQYKGJbwWssbgFa8gPiD6+1GhW1Rmg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I would like to load data from a file via file_fdw or COPY.. its a postgres
14 cluster

but.. One date (timestamp) column is written french order and another
column is written english order. Data comes from a state owned entity so
asking for a normalization may take ages.

obviously I could load as char and then apply an appropriate
transformation. no pb.
But is there a direct way to do this ?

thanks

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Nolan 2023-06-14 17:05:00 Re: date format
Previous Message Jan Wieck 2023-06-14 16:13:33 Re: Active Active PostgreSQL Solution