I have a flat file with a variable character date field that I need to convert to an Oracle date field. The flat file fields are delimited by a pipe (|) symbol. The input date could be in format MM/DD/YYYY or M/D/YYYY or MM/D/YYYY or M/DD/YYYY.
Is there a way to transform this data ?
This topic has been locked.