Converting string to date

jrtomici

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.

GrantSmith

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

GrantSmith

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

jrtomici

Great, thank you!