topic Re: Talend date Data Conversion Issue in Talend Studio

Talend date Data Conversion Issue

sushantk19 — Sat, 16 Nov 2024 03:01:37 GMT

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.

Re: Talend date Data Conversion Issue

manodwhb — Wed, 11 Mar 2020 03:05:27 GMT

@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.

Re: Talend date Data Conversion Issue

sushantk19 — Wed, 11 Mar 2020 08:58:53 GMT

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?

Re: Talend date Data Conversion Issue

manodwhb — Wed, 11 Mar 2020 09:02:26 GMT

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

Re: Talend date Data Conversion Issue

sushantk19 — Fri, 13 Mar 2020 11:32:59 GMT

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.

Re: Talend date Data Conversion Issue

manodwhb — Mon, 16 Mar 2020 03:47:14 GMT

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