Description:
ORA-01841 (full) year must be between -4713 and +9999, and not be 0
Cause:
A date specified a year that is not in the valid date range. A valid date is any date between January 1, 4712 B.C. and December 31, 9999 A.D.
Description:
ORA-01842 quarter must be between 1 and 4
Cause:
An invalid value was specified for the quarter of the year in a date. The quarter (Q) must be between 1 and 4.
Description:
ORA-01843 not a valid month
Cause:
A date specified an invalid month. Valid months are: January-December, for format code MONTH, and Jan-Dec, for format code MON.
Description:
ORA-01844 week of year must be between 1 and 52
Cause:
An invalid value was specified for the week of the year in a date. Week of the year (WW) must be between 1 and 52.
Description:
ORA-01845 week of month must be between 1 and 5
Cause:
An invalid value was specified for the week of the month in a date. Week of the month (W) must be between 1 and 5.
Description:
ORA-01848 day of year must be between 1 and 365 (366 for leap year)
Cause:
An invalid day of the year was specified in a date. Day of the year (DDD) must be between 1 and 365 for a non-leap year or 1 and 366 for a leap year.
Description:
ORA-01849 hour must be between 1 and 12
Cause:
An invalid hour was specified for a date using the 12-hour time format. If a 12-hour format code (HH or HH12) is used, the specified hour must be between 1 and 12.
Description:
ORA-01850 hour must be between 0 and 23
Cause:
An invalid hour was specified for a date using the 24-hour time format. If the 24-hour format code (HH24) is listed, the specified hour must be between 0 and 23.
Description:
ORA-01851 minutes must be between 0 and 59
Cause:
An invalid minute value was specified in a date. Minutes must be between 0 and 59.