oracle中字符截取 substr和instr就够了

select * from t_gwxx_gwsd t ORDER BY T.QSSJ
SELECT SUBSTR(T.QSSJ,3) FROM T_GWXX_GWSD T order by SUBSTR(T.QSSJ,3)
SELECT SUBSTR(T.QSSJ,3),SUBSTR(SUBSTR(T.QSSJ,3),0,INSTR(SUBSTR(T.QSSJ,3),':')-1) FROM T_GWXX_GWSD T order by to_number(SUBSTR(SUBSTR(T.QSSJ,3),0,INSTR(SUBSTR(T.QSSJ,3),':')-1))
/*SUBTR 是截取指定长度或位置的的字符
  INSTR 是某个字符在字符串中的位置
*/