hi sonal, I Have tried using TalendDate.parseDate("dd/MM/yyyy HH:mm:ss",row1.Value) and the result is Starting job UC_Pro_Preparation at 09:27 08/02/2013.
connecting to socket on port 3935 connected Exception in component tMap_1 java.lang.RuntimeException: java.text.ParseException: Unparseable date: "row1.pa_record_create_date" at routines.TalendDate.parseDate(TalendDate.java:744) at talend.uc_pro_preparation_0_1.UC_Pro_Preparation.tFileInputExcel_1Process(UC_Pro_Preparation.java:1956) at talend.uc_pro_preparation_0_1.UC_Pro_Preparation.runJobInTOS(UC_Pro_Preparation.java:2404) at talend.uc_pro_preparation_0_1.UC_Pro_Preparation.main(UC_Pro_Preparation.java:2272) Caused by: java.text.ParseException: Unparseable date: "row1.pa_record_create_date" at java.text.DateFormat.parse(Unknown Source) at routines.TalendDate.parseDate(TalendDate.java:742) ... 3 more disconnected Job UC_Pro_Preparation ended at 09:27 08/02/2013. Do you have any idea what is going wrong with the job? Thank you.
Hi Naim, One of the method to achieve this is by changing the data type from the edit schema option. # Double click on the tLogRow Component # Click on the edit schema option # Select the column which data type needs to be change # Change the data type form the drop down list available in the type column # Make these change in both the ends i.e. tLogRow as well as tFileInputExcel # You can also mention the desired pattern of the date in the Date pattern column For more details have a look in the attached snapshot. Best Regards, Mayur