STR_TO_DATE throwing Parsing error in ETL

Mukhilan · 2024-06-19T09:49:30+00:00

There was an error rendering this rich post.

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.

Find more posts tagged with

Date

Error

Data Flows

Accepted answers

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/

All comments

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/

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of