Oracle 截取字符串,取系统时间

select substr('JSL180415051260',4,4) from dual
select substr('JSL180415051260',8,6) from dual
select sysdate from dual
原文地址:https://www.cnblogs.com/xyzabc0004/p/5258439.html