STR_TO_DATE throwing Parsing error in ETL

Mukhilan

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.

DavidChurchman

%M is for full-month name "June".

Try %b for three-letter abbreviated month name.

That's as far as I got in checking, but I would double check the rest of your codes, too:

https://www.mysqltutorial.org/mysql-date-functions/mysql-date_format/

DavidChurchman

%M is for full-month name "June".

Try %b for three-letter abbreviated month name.

That's as far as I got in checking, but I would double check the rest of your codes, too:

https://www.mysqltutorial.org/mysql-date-functions/mysql-date_format/