Convert text to date

ozarkram

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

MichelleH

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

ozarkram

Hi @MichelleH : I am using ETL

ozarkram

Also my data looks like 2019-12-18

2020-01-21

ie of the format: yyyy-mm-dd

MichelleH

@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)

ozarkram

Hi @MichelleH : Really appreciate your help!