SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query containing SYSDATE - INTERVAL '1' YEAR fails for today's date(29th February 2016)

Ashwini PoojaryFeb 29 2016 — edited Feb 29 2016

Hi,

I'm facing this problem in my application where a query containing SYSDATE - INTERVAL '1' YEAR fails for today's date(29th February 2016). Can you please suggest a workaround for the same.

Query:

select TRUNC(SYSDATE) - INTERVAL '1' YEAR from dual;

Result:

ORA-01839: date not valid for month specified

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

*Cause:

*Action:

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 28 2016

Added on Feb 29 2016

7 comments

9,658 views