select substr('JSL180415051260',4,4) from dual select substr('JSL180415051260',8,6) from dual
select sysdate from dual
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