STR_TO_DATE throwing Parsing error in ETL


I am facing a error while converting string to date. This process is done in the ETL

Date column has value - Jun 11, 2024 @ 14:33:22.000

Formula - STR_TO_DATE(@timestamp, '%M %e, %Y @ %H:%i:%S.000')

The error showing is as attached below

Note : We receive data using email connector.

Please let me know where it is going wrong.

Best Answer