Convert text to date

ozarkram Member

July 2022 in Magic ETL

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:

• Formulas

0

Comments

• 

  MichelleH Coach

  July 2022

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

  1
• 

  ozarkram Member

  July 2022

  Hi @MichelleH : I am using ETL

  0
• 

  ozarkram Member

  July 2022

  Also my data looks like 2019-12-18

  2020-01-21

  ie of the format: yyyy-mm-dd

  0
• 

  MichelleH Coach

  July 2022

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

  
  

  3
• 

  ozarkram Member

  July 2022

  Hi @MichelleH : Really appreciate your help!

  1