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

select substr('JSL180415051260',4,4) from dual
select substr('JSL180415051260',8,6) from dual

 

select sysdate from dual