Skip to content

Converting string to date

jrtomici

jrtomici Member

January 2023 in Magic ETL

Hi,

I know there's a STR_TO_DATE function but maybe I could use more insight because it's not working. I have a date field that looks like this:

8-1-22

I want to convert this to a date. How can I achieve this with a ETL formula tile? Thank you.

Tagged:

0

Best Answer

GrantSmith Coach

January 2023 Answer ✓
You need to pass in the correct format string when converting your string to a date
STR_TO_DATE(`date`, '%c-%e-%y')
There a lot of references on format string codes on the internet but this is one you can reference: https://mysqlcode.com/mysql-str-to-date/#:~:text=Syntax%20of%20MySQL%20STR_TO_DATE%20%28%29%201%20%25a%20%E2%80%93,a%20numeric%20value%20%2801%20to%2031%29%20More%20items
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
0

Answers

GrantSmith Coach

January 2023 Answer ✓
You need to pass in the correct format string when converting your string to a date
STR_TO_DATE(`date`, '%c-%e-%y')
There a lot of references on format string codes on the internet but this is one you can reference: https://mysqlcode.com/mysql-str-to-date/#:~:text=Syntax%20of%20MySQL%20STR_TO_DATE%20%28%29%201%20%25a%20%E2%80%93,a%20numeric%20value%20%2801%20to%2031%29%20More%20items
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
0
jrtomici Member

January 2023

Great, thank you!

0

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.

Categories