select * from TableTest where to_date(srulecode,'mm-dd') > sysdate
select * from TableTest where to_date(SRuleCode,'MM-DD') > sysdate
select * from TableTest where to_char(SRuleCode处理成DateTime,'mm-dd') > to_char(sysdate,'mm-dd')
2楼的可以用,谢了,to_char()报不能转为number错误,结帖
CREATE TABLE test(col1 varchar(5));insert into test(col1) values('09-22'); insert into test(col1) values('09-18'); insert into test(col1) values('09-19'); insert into test(col1) values('09-24'); insert into test(col1) values('09-30');SELECT * FROM test WHERE col1 > TO_CHAR(SYSDATE,'mm-dd');
select * from TableTest where to_char(SRuleCode处理成DateTime,'mm-dd') > to_char(sysdate,'mm-dd')
insert into test(col1) values('09-18');
insert into test(col1) values('09-19');
insert into test(col1) values('09-24');
insert into test(col1) values('09-30');SELECT * FROM test
WHERE col1 > TO_CHAR(SYSDATE,'mm-dd');