CSV Parser, specify date format
I'm using COPY with fdelimitedparser. I would like to be able to specify a date or datetime format for some of the columns, since different date columns can have different formats.
I can't list all columns like when using COPY without a parser, since I have many files with different column combinations, and I would rather avoid writing a script to generate my copy command for each file.
Is there any way to do this ?
Additionally, how do I know which parser natively accepts which date format ?