I am trying to import a CSV file that contains dates whose format is MMDDYYYY, but Postgres is expecting YYYYMMDD and the CSV file keeps failing to load.
I have tried amending the CSV file in Excel and reloading, but the load still recognises the original date format of MMDDYYYY
Is there a way to make it work?