--转换为date类型 然后与sysdate进行比较 if to_date('2011-06','yyyy-mm')<=sysdate then dbms_output.put_line(0); else then dbms_output.put_line(1);
select sing(to_date('2011-06','yyyy-mm')-sysdate)+1 from dual
select sign(to_date('2011-06','yyyy-mm')-sysdate)+1 from dual上面打错了,是SIGN函数
select (case when to_date('2011-06','yyyy-mm')<=sysdate then 0 else 1 end) from dual(CASEWHENTO_DATE('2011-06','YYYY-MM')<=SYSDATETHEN0ELSE1END) ------------------------------------------------------------ 1
if to_date('2011-06','yyyy-mm')<=sysdate then
dbms_output.put_line(0);
else then
dbms_output.put_line(1);
select (case when to_date('2011-06','yyyy-mm')<=sysdate
then 0 else 1 end) from dual(CASEWHENTO_DATE('2011-06','YYYY-MM')<=SYSDATETHEN0ELSE1END)
------------------------------------------------------------
1