Impala:
时间 String--->Date :
from_unixtime(unix_timestamp(trunc(to_date(DELIVER_DATE),'MONTH')),'yyyyMMdd') as DELIVER_DATE
Presto(且向前推一天):
时间 String--->Date :
date_format(date_parse(end_date_12M,'%Y%m%d')+interval '-1' day,'%Y%m%d') qj_date,
注: presto有个坑,substring ( a,0,2)是不支持0的,要从1开始,例如substring(a,1,2)