Date Format: Convert string date to null

One Star

Date Format: Convert string date to null

Hi,
I am loading text file data into oracle table. Text file contains date value in string format 'yyyymmdd'.
Loading works fine for valid dates but when text file containg date value as '00000000', it gets converted to '30'Nov-0002' date in Oracle (unknown value).
Could you please help me in formatting '00000000' date string to replace by NULL?
Thanks,
Neil
One Star

Re: Date Format: Convert string date to null

Hi Neil
This topic is related to http://www.talendforge.org/forum/viewtopic.php?pid=78371#p78371.
Regards,
Pedro