issues with date format

Anonymous — Sat, 16 Nov 2024 11:59:57 GMT

hii all,
I am using talend MDM v5.2.2 with java
i am trying to fetch data(date column) from excel file.
date format is "DD/MM/YYYY". I converted it to" YYYY-MM-DD" using tjavarow. Now i want to insert this record in a table on MDM server.
texcelFile--> tjavarow-->tlogrow1-->tmap-->tlogrow2-->tmdmoutput
format is properly shown in tjavarow but in tlogrow1 it changes
eg:
Destination Date : 2013-07-08
2013-07-189|MY|MY-02|W
Destination Date : 2013-07-09
2013-07-190|MY|MY-02|H
Destination Date : 2013-07-10
2013-07-191|MY|MY-02|W
Destination Date : 2013-07-11
2013-07-192|MY|MY-02|W
Destination Date : 2013-07-12
2013-07-193|MY|MY-02|W
Destination Date : 2013-07-13
2013-07-194|MY|MY-02|W
Destination Date : 2013-07-14
2013-07-195|MY|MY-02|W
Destination Date : 2013-07-15
2013-07-196|MY|MY-02|W
Destination Date : 2013-07-16
10000013|2013-01-15|||W|
Can somebody help me out

Re: issues with date format

Anonymous — Sat, 15 Jun 2013 17:18:13 GMT

Hi,
Check the Pattern in the schema of the input component that reads the Excel file. If you set the proper format there, you don't need to convert strings. The date will be loaded a Date object.
Can you send some screenshots, specially the input schema window? Also some sample of the input data will help you get some answers.
Regards,
Thiago

topic issues with date format in Talend Studio

issues with date format

Re: issues with date format