Error List

Error List for the ‘ORA-01500 to ORA-02099’ Category

ORA-01841 (full) year must be between -4713 and +9999, and not be 0

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.

admin ORA-01500 to ORA-02099

ORA-01842 quarter must be between 1 and 4

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.

admin ORA-01500 to ORA-02099

ORA-01843 not a valid month

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.

admin ORA-01500 to ORA-02099

ORA-01844 week of year must be between 1 and 52

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.

admin ORA-01500 to ORA-02099

ORA-01845 week of month must be between 1 and 5

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.

admin ORA-01500 to ORA-02099

ORA-01846 not a valid day of the week

Description:
ORA-01846 not a valid day of the week

Cause:
A date specified an invalid day of the week. Valid days are:

  • Monday-Sunday, for format code DAY
  • Mon-Sun, for format code DY
  • 1-7, for format code D

Action: Enter a valid day of the week value in the correct format.

admin ORA-01500 to ORA-02099

ORA-01848 day of year must be between 1 and 365 (366 for leap year)

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.

admin ORA-01500 to ORA-02099

ORA-01849 hour must be between 1 and 12

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.

admin ORA-01500 to ORA-02099

ORA-01850 hour must be between 0 and 23

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.

admin ORA-01500 to ORA-02099

ORA-01851 minutes must be between 0 and 59

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.

admin ORA-01500 to ORA-02099