Extract Y-M-D from BATCH_LAST_RUN

Hi, I need to extract the year-month-day from the timezone column. The column BATCH_LAST_RUN has values like: `2021-06-24 07:15:04 AM UTC`, what I need is to convert the date to est zone and just have the values like: 2021-06-24


I tried: DATE_FORMAT(MAX(DATE_SUB(`_BATCH_LAST_RUN_`)), '%Y-%m-%d '))

Also, tried to apply CONVERT_TIMEZONE function but nothing worked.

Answers