Oracle 截取字符串,取系统时间 select substr('JSL180415051260',4,4) from dual select substr('JSL180415051260',8,6) from dual select sysdate from dual