select * from good_user_04 a where user_state in ('申请停机','申请停,欠费双停') and months_between(to_timestamp(a.last_stop_time,'yyyyMMddHHmmss'),to_timestamp(a.open_date,'yyyyMMddHHmmss')) <=12;
IMPALA取时间月份差
最新推荐文章于 2024-02-21 11:37:20 发布
select * from good_user_04 a where user_state in ('申请停机','申请停,欠费双停') and months_between(to_timestamp(a.last_stop_time,'yyyyMMddHHmmss'),to_timestamp(a.open_date,'yyyyMMddHHmmss')) <=12;