格式不对吧
02031200 代表 YYMMDDHH24 ??
02 年03 月 12 日 00是什么?

解决方案 »

  1.   

    SQL> declare
      2   tmp char(10):='02101000';
      3  begin
      4   if to_date(tmp,'YYMMDDHH24') > to_date('02031200','YYMMDDHH24') then
      5   dbms_output.put_line('大于');
      6   end if;
      7  end;
      8  /
    大于PL/SQL procedure successfully completed
      

  2.   

    可以比较的,如:
    SQL>  select to_date('02032000','YYMMDDHH24')-to_date('02031200','YYMMDDHH24') from dual;TO_DATE('02032000','YYMMDDHH24')-TO_DATE('02031200','YYMMDDHH24')
    -----------------------------------------------------------------
                                                                    8SQL> select to_date('02032010','YYMMDDHH24')-to_date('02031200','YYMMDDHH24') from dual;TO_DATE('02032010','YYMMDDHH24')-TO_DATE('02031200','YYMMDDHH24')
    -----------------------------------------------------------------
                                                            8.4166667