Currently we have an ability to specify a custom date/timestamp format per file load/extract using COPY utility via DATETIMEFORMAT option.
This puts a limitation that all date/ts columns in a particular csv have to conform to the same format. e.g. my file has DOB and incorporation_date for an employee. But the format for both is not same since they come from different systems.
So, I don't have the ability yet in C* to handle this situation (which is quite common given a disparate ecosystem of extracts).
We should be able to rather specifiy the format for each date/ts field separately instead for ease of ingestion especially.