1 时间格式转换:
2018-01-03 转化为 20180103;
select regexp_replace(substr(effc_start_dt,1,10),'-','') from tmp_lj_shenpi_shaixuan_0102
limit 5;
2 datediff函数使用:
注意:datediff()函数只能用于 2018-01-03 00:00:00格式时间;
其中,effc_start_dt格式为 2018-01-03 00:00:00;dt格式为20180103;
datediff(substr(b.effc_start_dt,1,10),concat(substr(a.dt,1,4),'-',substr(a.dt,5,2),'-',substr(a.dt,7,2),'-')));