IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
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 ?