Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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