Date Format Parsing

Anonymous — Sat, 16 Nov 2024 02:39:02 GMT

Hi All,

I need below date conversions:

Source:

Monday, April 13, 2020 6:27 PM ----> (Which has two commas)

Target:

2020-04-13 18:27:00

2020-04-13T18:27:00

I tried using below in tmap:

TalendDate.parseDateLocale("yyyy MMM dd HH:mm:ss",row7.SchedDt ,"EN") ---> (SchedDt is src column)

Facing below error:

java.lang.RuntimeException: java.text.ParseException: Unparseable date: "Monday, April 13, 2020 6:27 PM"

Please help to rectify the issue asap.

Thanks in advance.

Re: Date Format Parsing

Anonymous — Mon, 20 Apr 2020 08:39:46 GMT

try this expression:
TalendDate.parseDateLocale("EEEE, MMMM dd, yyyy hh:mm aa", s, "en")

Regards
Shong