Date parsing

Anonymous — Wed, 08 Apr 2020 23:51:02 GMT

I am reading and excell column which stores date. The format i am receiving the date is as below

Thu Apr 02 00:00:00 CDT 2020

So i am trying to convert it into date with following statement in tJavaRow componenet

Thu Apr 02 00:00:00 CDT 2020

output_row.effective_date = TalendDate.parseDate("E MMM dd hh:mm:ss z yyyy",input_row.effective_date);

But after conversion the date i am receiving is one day before of the day i am receiving, i.e in this case it 01-Apr-2020.

What could be possible reason?

Thanks

Saswata

Re: Date parsing

akumar2301 — Mon, 13 Apr 2020 19:43:28 GMT

You are not in CDT timezone. Date us converted to your local timezone datetime.