Skip to main content

CSV Parser, specify date format

  • August 16, 2016
  • 0 replies
  • 9 views

bezout

Hello,

 

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 ?

 

Thanks