Can you use a CASE statement? The real issue with date conversion is
not knowing if a value of 02-03-2023 is mm-dd-yyyy or dd-mm-yyyy.
On Wed, Jun 14, 2023 at 11:42 AM Marc Millas <marc.millas@mokadb.com> wrote:
>
> 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
froma 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
>