ORA-01839: date not valid for month specified : ORA Error « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. ORA Error

ORA-01839: date not valid for month specified

  

SQL> select date '1996-01-29' + interval '1' month as col_1
  2  ,      date '1997-01-29' + interval '1' month as col_2
  3  ,      date '1997-08-11' - interval '3' month as col_3
  4  from   dual;
,      date '1997-01-29' + interval '1' month as col_2
                         *
ERROR at line 2:
ORA-01839: date not valid for month specified


SQL>
SQL> select date '1996-01-29' + interval '1' month as col_1
  2  ,      date '1997-01-28' + interval '1' month as col_2
  3  ,      date '1997-08-11' - interval '3' month as col_3
  4  from   dual;
Enter...

29-02-1996 28-02-1997 11-05-1997

1 row selected.

SQL>








Related examples in the same category

1.ORA-00918: column ambiguously defined
2.ORA-00934: group function is not allowed here
3.ORA-00979: not a GROUP BY expression
4.ORA-01403: no data found
5.ORA-01403: no data found exception from procedure
6.ORA-01422: exact fetch returns more than requested number of rows
7.ORA-01426: numeric overflow
8.ORA-06502: PL/SQL: numeric or value error
9.ORA-06502: PL/SQL: numeric or value error: character to number conversion error
10.ORA-06502: PL/SQL: numeric or value error: number precision too large
11.ORA-06503: PL/SQL: Function returned without value
12.ORA-14551: cannot perform a DML operation inside a query