mysql截取后八位_截取字符串中前8个数字
先替换非数字的为空，再截取with tmp_a as (select '2018-10-15 12:30:59' update_time from dual union all --结果是 20181015select '2017/10/16 12:30:59' update_time from dual union all --结果是 20171016select '20151015 12:30...
