假设你的表为T,日期字段为D 你录入条件中的格式可以自己调整,修改这里TO_DATE('2014-03-04','YYYY-MM-DD') SELECT * FROM T WHERE TO_DATE(SUBSTR(D,1,INSTR(D,' ')-1),'DD-MON-YY') >TO_DATE('2014-03-04','YYYY-MM-DD')
一样的啊 SELECT * FROM T WHERE TO_DATE(SUBSTR(D,1,INSTR(D,' ')-1),'DD-MON-YY') between TO_DATE('2014-01-01','YYYY-MM-DD') and TO_DATE('2014-12-31','YYYY-MM-DD')
你录入条件中的格式可以自己调整,修改这里TO_DATE('2014-03-04','YYYY-MM-DD')
SELECT * FROM T
WHERE TO_DATE(SUBSTR(D,1,INSTR(D,' ')-1),'DD-MON-YY')
>TO_DATE('2014-03-04','YYYY-MM-DD')
SELECT * FROM T
WHERE TO_DATE(SUBSTR(D,1,INSTR(D,' ')-1),'DD-MON-YY')
between TO_DATE('2014-01-01','YYYY-MM-DD')
and TO_DATE('2014-12-31','YYYY-MM-DD')
需要对“月”后面的空格处理下
TO_DATE(SUBSTR(replace(D,'月 ',''),1,INSTR(replace(D,'月 ',''),' ')-1),'DD-MM-YY')