• No replies
1 Post

Pinned topic How to convert variable character date field in flat file to Oracle date

‏2012-02-08T21:57:51Z |
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 ?