2022-05-30

interval '3' months on 30May --> throws an error because there is no 30 FEB

select sysdate - interval '3' month from dual;

 ORA-01839: date not valid for month specified

01839. 00000 -  "date not valid for month specified"

*Cause:    

*Action:


Solution: select sysdate - interval '90' day from dual;

Niciun comentariu:

Trimiteți un comentariu