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
Hi @ozarkram are you using ETL or Beast mode? Also could you share a few examples of what your MFGDTE values look like?
MFGDTE
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!