regexp_replace(cast(date_sub(from_unixtime(unix_timestamp('${date}','yyyymmdd'),'yyyy-mm-dd'),10) as string),'-','')