perl -p -i.bak -e "s/CAST(CAST(hs_date AS DATE FORMAT 'YYYYMMDD') AS CHAR(08)) as hs_date/FORMAT_DATE(hs_date, 'YYYYMMDD') as hs_date/g;" HealthList