Hi Talend Support officer,
Can you tell me how can I convert the string data of "14/09/2001" from MS Access to DB2 date format ("yyyy-mm-dd") as "2001-09-14" by using tMap function in Talend Open Studio, please?
But i entered the rows in excel in the meaning of dd/MM/yyyy............... if i used parsed date fuction in tmap i got all the rows. this is only ok for tlogrow but not for tmssqloutput.
2. If i used Date column with string datatype in tfileinputexcel , i did not get any row in tmssqloutput
Tfileinputecxel(Date date)-tmap output as date datatype. error is Only dates between January 1, 1753 and December 31, 9999 are accepted.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Practical steps to developing your data integration strategy.