You are not logged in.
I am loading text file in to oracle database. Text file contains strings of dates in 'yyyymmdd' format.
I am transferring them into oracle table in 'dd-MM-yyyy' format. This works fine until text file comes across a value(date) '00000000'.
This gets converted to '30-Nov-0002' in Oracle.
Could anyone please help me in formatting the string to get null if string value is '00000000'?
Thanks Pedro but that did not help.
I got following error.
Exception in component tMap_4
Tried converting row1 to string type but it gives conversion error.
I tried your suggestion.
I got error
Type mismatch: cannot convert from Object&Serializable&Comparable<?> to Date