Convert text to date

ozarkram · 2022-07-27T14:50:26+00:00

There was an error rendering this rich post.

Hi All,

I am trying to convert a string to date...

STR_TO_DATE(`MFGDTE`,'%Y-%m-%d')

But I am getting the value as 2019-12-18t00:00-06:00 ...Can you please let me know how to get just the date

Find more posts tagged with

Formulas

Hi @ozarkram are you using ETL or Beast mode? Also could you share a few examples of what your MFGDTE values look like?

Hi @MichelleH : I am using ETL

Also my data looks like 2019-12-18

2020-01-21

ie of the format: yyyy-mm-dd

@ozarkram It looks like you just need to cast your result to a date rather than datetime like this:

CAST(STR_TO_DATE(`MFGDTE`,'%Y-%m-%d') as DATE)

Hi @MichelleH : Really appreciate your help!