7 Replies Latest reply: Jan 18, 2013 7:12 AM by SShubhangi RSS

    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 :(