I am getting date as 1/1/1800 from the input excel. Type is String. How to pass this value to destination Database.
I received an error that its "Unparseable date" Please suggest
Solved! Go to Solution.
If 1/1/1800 is of the format M/d/yyyy then parse it as TalendDate.parseDate("M/d/yyyy",row1.date) in the target while parsing from the excel .Please make change in the parsedate function based on the format in the source.
I am already having this code for other proper date's from the input. Only 3 rows are having this 1/1/1800 (m/d/yyyy). Please suggest how to handle this now
("".equals(row1.Date) || row1.Date == null ? null : TalendDate.parseDateLocale("EEE MMM dd HH:mm:ss zzz yyyy",row1.Date,"EN"))
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.