17,082
社区成员
发帖
与我相关
我的任务
分享
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')
SELECT * FROM T
WHERE TO_DATE(SUBSTR(D,1,INSTR(D,' ')-1),'DD-MON-YY')
>TO_DATE('2014-03-04','YYYY-MM-DD')
TO_DATE(SUBSTR(replace(D,'月 ',''),1,INSTR(replace(D,'月 ',''),' ')-1),'DD-MM-YY')
20-8月 -14 11.40.01.629000000 上午