01 2019 档案

截取字符串中前8个数字
摘要：先替换非数字的为空，再截取 with tmp_a as ( select '2018-10-15 12:30:59' update_time from dual union all --结果是 20181015 select '2017/10/16 12:30:59' update_time fro 阅读全文
posted @ 2019-01-11 14:25 江清风 阅读(1182) 评论(0) 推荐(0)