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
