Stepwise-Lab

ORA-01839: Date not valid for month specified

The date does not exist: for example 31 February, often from adding INTERVAL '1' MONTH to a month end. ADD_MONTHS adjusts to the last day of the month instead.

On the exam

This error belongs to the topic Time zones and intervals of exam 1Z0-071.

In the SQL lab the same explanation appears next to your own statement, with a hint about what to change in it.

All Oracle errors