Convert text to date

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

Tagged:

Comments