1. 分割字符串
t1.KDRQ as issue_date , --- 开单日期
split(t1.KDRQ,'-')[0] as issue_year , --销售——年
split(t1.KDRQ,'-')[1] as issue_month , --销售——月
split(t1.KDRQ,'-')[2] as issue_day , --销售——日
2. 拼接字符串
concat(split(t1.KDRQ,'-')[0],split(t1.KDRQ,'-')[1]) as issue_yearMonth , --销售——年月
3. 日期提取
dayOfWeek(t1.KDRQ) as issue_weekday , -- 周几