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.mil...@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 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 >
