Date parsing

[Anonymous]

Hi

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

[akumar2301]

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