7 Replies Latest reply on Jan 18, 2013 1:12 PM by SShubhangi

    ORA-01841 :(full) year must be between -4713 and +9999, and not be 0

    SShubhangi
      Hello Guys,

      While excuting below statement

      SELECT TO_DATE('31-aug-12','DD-MON-YY'),TO_DATE('1-SEPT-12','DD-MON-YY'),120 FROM DUAL

      getting error...

      ORA-01841 :(full) year must be between -4713 and +9999, and not be 0

      previously it was working :(