hi all, i am new to talend My sourece is csv, there in date column i have date date in "MM/DD/YYYY" pattern, when tried that to load in staging table . I am getting the error "UNPARSED DATE" My db is oracle here defaoult pattern is dd-mm-yyyy, i tried talend.parsedate in tmap also any help.....
Hi, I can't find your screen shot. But between file and staging table i am using Tschemacompliancechaeck component to check the datatype, so all the records stopped there itself...and it shows that Unparseable date: "5/31/2011"
Just change date pattern in edit schema menu. If the date is in the format "MM/DD/yyyy", you should set date pattern to "MM/DD/YYYY" (for the input file). For writing in a db table in format "MM-dd-YYYY", just edit the tDb_nameOut component schema and set date pattern there to "MM-dd-yyyy".
tfileinputdelimited | ---> toracleoutput (for the date field | (for the datefield set the date pattern "dd-MM-YYYY" in toracleoutput schema) set date pattern to | "MM/dd/YYYY" in the tfileinputdelimited schema) what is the error shown? copy-paste the err msg