Talend date Data Conversion Issue

[sushantk19]

Hi,

I am extracting data from a Relation Database using HeidiSQL client. Source date value is '2015-12-07 19:03:13'; I create a simple Talend Job to extract the data from this table to .csv file. BUt storing the data in relevant date field in .csv, the value is coming is 07/12/2015 20:03:13 PM. It is storing the date correctly, but the time is 1 hour ahead then what it should be? how can we handle this in Talend code itself as I have very less knowledge on Java.

[manodwhb]

@sushantk19 , yes it will store correctly,since you might seeing difference when you open in excel,you should open that csv file in notepad++ or some other editor then you will find the exact format what you have extracted from Table.

[sushantk19]

I changed the datatype to Date for sourec data and ran the job again. I checked the output in wordpad/notepad, but it is still refeclting as 07-12-2015 20:03:13 which is not correct; Am i missing something here?

[manodwhb]

@sushantk19 , can you share your job design and date column date format also?

[sushantk19]

The Job Design is very simple:

tDBInput(MYQSL)---->tLogRow---->tFileOutputDelimited,

Source date format is 

Col name    TYPE     DB TYPE             Date Pattern

created_at   DATE      DATETIME     "dd-MM-yyyy HH:mm:ss"

If i make it String varchar 255, then it loads perfectly in .csv file.

[manodwhb · Accepted solution]

@sushantk19 , is dd-MM-yyyy HH:mm:ss format have used in tFileOutputDelimited also?