01800-01899: The Date Function

This section lists messages generated when the Oracle date function is accessed.

Cause:	A literal specified in a date format was too large. If a literal is entered as a date, it must be less than 220 characters long.

Action:	Use only literals less than 220 characters long in the date format.

ORA-01801 date format is too long for internal buffer

Cause:	The date format string was too long to process. This should occur only if several long literals are specified as part of a date.

Action:	Remove long literals from the date format string.

ORA-01802 Julian date is out of range

Cause:	An invalid Julian date was entered. Valid Julian dates run from 1 to 3,442,447.

Action:	Enter a valid Julian date between 1 and 3,442,447.

ORA-01803 failure in getting date/time

Cause:	This is an internal error message that is not likely to occur. It is usually caused by a failure in the system clock.

Action:	Investigate the system clock and the process that requested the date or time. If necessary, contact customer support.

ORA-01810 format code appears twice

Cause:	A format code was listed twice in a date specification. Each format code may be specified only once in the function TO_DATE.

Action:	Remove the duplicate format code from the date specification, then retry the operation.

ORA-01811 Julian date precludes use of day of year

Cause:	Both a Julian date and a day of the year were specified in the TO_DATE function. If a Julian date is specified, the day of the year (DDD) may not be specified, as it is contained in the Julian date.

Action:	Remove the day of the year or the Julian date from the specification, then retry the operation.

ORA-01812 year may only be specified once

Cause:	More than one year format code was listed in a date specification. Only one of the following year format codes may be specified in a date: YYYY, YYY, YY, Y.

Action:	Remove all but one year format from the date specification.

ORA-01813 hour may only be specified once

Cause:	More than one hour format code was listed in a date specification. Only one of the following hour format codes may be specified in a date: HH, HH12, HH24.

Action:	Remove all but one hour format from the date specification.

ORA-01814 AM/PM conflicts with use of A.M./P.M.

Cause:	Both types of meridian indicators, AM and PM, were listed in a date specification. If one of the meridian indicator format masks, such as AM or A.M., is specified in the date, the other may not be specified.

Action:	Use one meridian indicator format, with or without periods, consistently.

ORA-01815 BC/AD conflicts with use of B.C./A.D.

Cause:	Both types of BC/AD indicators were listed in a date specification. If one of the BC/AD indicator format masks, such as BC or B.C., is specified in the date, the other may not be specified.

Action:	Use one BC/AD indicator format, with or without periods, consistently.

ORA-01816 month may only be specified once

Cause:	More than one month format code was listed in a date specification. Only one of the following month format codes may be specified in a date: MM, MON, MONTH.

Action:	Remove all but one month format from the date specification.

ORA-01817 day of week may only be specified once

Cause:	More than one day-of-the-week format code was listed in a date specification. Only one of the following day-of-the-week format codes may be specified in a date: D, DY, DAY.

Action:	Remove all but one day-of-the-week format from the date specification.

ORA-01818 HH24 precludes use of meridian indicator

Cause:	A date specification contained both a 24-hour time format code and a meridian indicator code. If hours are specified using the 24-hour time format (HH24), a meridian indicator, AM or PM, may not be specified.

Action:	Remove the meridian indicator format code, AM/PM or A.M./P.M., or the 24-hour time format code, HH24, from the date specification.

ORA-01819 signed year precludes use of BC/AD

Cause:	A date specification contained both a signed year and a B.C./A.D. indicator. If the year is specified with a sign, such as SYYYY, then B.C. or A.D. is implicit in the date and must not be entered.

Action:	Remove the B.C./A.D. indicator from the date specification.

ORA-01820 format code cannot appear in date input format

Cause:	A date specification contained an invalid format code. Only the following may be specified when entering a date: year, month, day, hours, minutes, seconds, Julian day, A.M./P.M. and B.C./A.D.

Action:	Remove the invalid format code from the date specification.

ORA-01821 date format not recognized

Cause:	A date specification contained an invalid format code.

Action:	Check that only valid date format codes are specified.

ORA-01830 date format picture ends before converting entire input string

Cause:	A valid date format picture included extra data. The first part of the format picture was converted into a valid date, but the remaining data was not required.

Action:	Check the specifications for date format pictures and correct the statement.

ORA-01831 year conflicts with Julian date

Cause:	The wrong year was specified with a Julian day. If a year is specified with a Julian date, it must be the year in which the Julian date occurs.

Action:	Remove the year value from the date specification or enter the correct year for the Julian date.

ORA-01832 day of year conflicts with Julian date

Cause:	A Julian date was specified with the day of the year but the day did not correspond to the Julian date. If the day of the year is specified with a Julian date, it must be the same day as the Julian date.

Action:	Remove the day of the year value from the date specification or enter the correct day for the Julian date.

ORA-01833 month conflicts with Julian date

Cause:	The wrong month was specified with a Julian date. If a month is specified with a Julian date, it must be the month in which the Julian date occurs.

Action:	Remove the month value from the date specification or enter the correct month for the Julian date.

ORA-01834 day of month conflicts with Julian date

Cause:	A Julian date was specified with the day of the month, but the month day did not correspond to the Julian date. If the day of the month is specified with a Julian date, it must be the same day of the month as the Julian date.

Action:	Remove the day of the month value from the date specification or enter the correct day of the month for the Julian date.

ORA-01835 day of week conflicts with Julian date

Cause:	A Julian date was specified with the day of the week, but the weekday did not correspond to the Julian date. If the day of the week is specified with a Julian date, it must be the same day of the week as the Julian date.

Action:	Remove the day of the week value from the date specification or enter the correct day of the week for the Julian date.

ORA-01836 hour conflicts with seconds in day

Cause:	The wrong hour was specified with seconds in the day. If an hour is specified with seconds past midnight (SSSSS), it must be the hour in which the seconds value falls.

Action:	Remove the hour value from the date specification or specify the correct hour for the seconds past midnight.

ORA-01837 minutes of hour conflicts with seconds in day

Cause:	A date specification contained both minutes of the hour and seconds in the day but the values did not correspond. If both minutes in the hour (MI) and seconds past midnight (SSSSS) are specified, the minutes value must be the minute in which the seconds value will occur.

Action:	Remove the minutes value from the date specification or enter the correct minute value for the specified seconds value.

ORA-01838 seconds of minute conflicts with seconds in day

Cause:	A date specification contained both seconds of the minute and seconds in the day but the values did not correspond. If both types of seconds are specified, the seconds of the minute value (SS) must be the second in which the seconds past midnight value (SSSSS) will fall.

Action:	Remove the seconds of the minute value from the date specification or enter a value that corresponds to the given seconds in the day.

ORA-01839 date not valid for month specified

Cause:	The day of the month specified in the date is invalid for the given month. The day of the month (DD) must be between 1 and the number of days in the month.

Action:	Enter a valid day of the month for the specified month.

ORA-01840 input value not long enough for date format

Cause:	The data to be converted to date format was incomplete; the date format picture was longer than the input data.

Action:	Either add more input or shorten the date picture format, then retry the operation.

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

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, 4712 A.D.

Action:	Enter a valid date value between 4712 B.C. and 4712 A.D.

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.

Action:	Enter a value for quarter between 1 and 4.

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.

Action:	Enter a valid month value in the correct format.

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.

Action:	Enter a week of the year value between 1 and 52.

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.

Action:	Enter a week of the month value between 1 and 5.

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

Cause:	The day of the month listed in a date is invalid for the specified month. The day of the month (DD) must be between 1 and the number of days in that month.

Action:	Enter a valid day value for the specified month.

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.

Action:	Enter a day of the year value between 1 and 365 (or 366).

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.

Action:	Enter an hour value between 1 and 12.

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.

Action:	Enter an hour value between 0 and 23.

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.

Action:	Enter a minute value between 0 and 59.

ORA-01852 seconds must be between 0 and 59

Cause:	An invalid seconds value was specified in a date. Seconds must be between 0 and 59 if the seconds format code (SS) is used.

Action:	Enter a seconds value between 0 and 59.

ORA-01853 seconds in day must be between 0 and 86399

Cause:	An invalid value for seconds in the day was specified in a date. Seconds must be between 0 and 86399 if the seconds past midnight format code (SSSSS) is used.

Action:	Specify a seconds value between 0 and 86399.

ORA-01854 Julian date must be between 1 and 5373484

Cause:	An invalid Julian date was entered.

Action:	Correct and retry.

ORA-01855 AM/A.M. or PM/P.M. required

Cause:	A date specification contained a meridian indicator format code but a valid meridian indicator was not specified. If a meridian indicator code, A.M./P.M. or AM/PM, is included in a date format, the date must include a valid meridian indicator.

Action:	Specify the meridian indicator in the correct format, A.M./AM or P.M./PM.

ORA-01856 BC/B.C. or AD/A.D. required

Cause:	A date specification contained a BC/AD format code but a valid BC/AD indicator was not specified. If one of the BC/AD format codes, BC/AD or B.C./A.D., is specified in a date format, the date must include BC/B.C. or AD/A.D.

Action:	Specify the BC/AD indicator in the date using the correct format.

ORA-01857 not a valid time zone

Cause:	An incorrect time zone code was specified for the NEW_TIME function.

Action:	Correct the invalid time zone code, then retry the operation.

ORA-01858 a non-numeric character found where a digit was expected

Cause:	The input data to be converted using a date format model was incorrect. The format model expected a number but found a non-numeric character.

Action:	Check the input data and the date format model to make sure the elements match in number and type, then retry the operation.

ORA-01859 a non-alphabetic character was found where a letter was expected

Cause:	The input data to be converted using a date format model was incorrect. The format model expected a letter but found a non-alphabetic character.

Action:	Check the input data and the date format model to make sure the elements match in number and type, then retry the operation.

ORA-01860 week of year must be between 1 and 53

Cause:	A week number outside the range 1 to 53 was specified.

Action:	Use only a value within the valid range for the week number.

ORA-01861 literal does not match format string

Cause:	Literals in the input string must be the same length as the literals in the format string, except for the leading white space characters. If the "FX" modifier is specified, the literal must match exactly, including the leading white space.

Action:	Correct the format string to match the string literal.

ORA-01862 wrong number of digits for this format item

Cause:	The number of digits in this format item is not equal to the number required for the format. This error usually occurs when the "FX" modifier (format exact) has been specified.

Action:	Resubmit the command using the required amount of numbers for the format mask.

ORA-01898 too many precision specifiers

Cause:	While trying to truncate or round dates, extra data was found in the date format picture.

Action:	Check the syntax of the date format picture and retry.

ORA-01899 bad precision specifier

Cause:	An invalid precision code was specified in a date.

Action:	Enter a valid precision code in the date format. Valid precision types are: century, year, month, day, Julian date, hours, minutes, and seconds.