Oracle DBA, How To, Error, Cause and Action

ORA-01282: date range specified is invalid

ORA-01282: date range specified is invalid




Cause: startTime may be greater than endTime. startTime or endTime may be greater than year 2110. startTime may be less than year 1988.




Action: Specify a valid date range.