You are not logged in.
I tend to use a string for output and let the database sort it out.
I tried your suggestion.
I got error
Type mismatch: cannot convert from Object&Serializable&Comparable<?> to Date
Have you tried passing an empty value? Not sure if you can do this to a date field.
What is the code at the error line?
Does your output field allow for nulls?
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.
Say that the column is called time.
Set expression in tMap as follow.
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'?