select case when sysdate-date'2012-03-11' > 0 then '当前时间大' else '当前时间小' end b_date from dual
应该是这样SELECT * FROM table WHERE JSSJ(数据库里的日期) >= (select to_date(sysdate) from dual)
SELECT * FROM table WHERE JSSJ >= sysdate
select case when '2012-03-12' > to_char(sysdate,'yyyy-mm-dd') then '大于当前时间' when '2012-03-12' = to_char(sysdate,'yyyy-mm-dd') then '等于当前时间' when '2012-03-12' < to_char(sysdate,'yyyy-mm-dd') then '小于当前时间' end from dual;
select case when sysdate-date'2012-03-11' > 0 then '当前时间大' else '当前时间小' end b_date
from dual
SELECT * FROM table WHERE JSSJ >= sysdate
when '2012-03-12' = to_char(sysdate,'yyyy-mm-dd') then '等于当前时间'
when '2012-03-12' < to_char(sysdate,'yyyy-mm-dd') then '小于当前时间'
end
from dual;