Date Format Parsing

[Anonymous]

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

or

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.

[Anonymous]

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

Regards
Shong