格式：substr(string,startindex,length) 示例：select * from tbl_faxreceivelist where substr(starttime,4,4)='Dec' and (to_number(substr(starttime,8,3))>=1 and to_number(substr(starttime,8,3))<=7) or (substr(starttime,6,2)='12' and to_number(substr(starttime,9,3))>=1 and to_number(substr(starttime,9,3))<=7)

评论