Specifying date format for external tables
I am trying to define an external table that has a date in it. The date in the file is formatted MM/DD/YYYY. I can't figure out how to specify it as a date in the external table definition. I have tried: DATE_RECORDED date "mm/dd/yyyy" and I keep getting an ORA-00907: missing right parenthesis error. Anyone know what I am doing wrong?
Richard
Richard
0