ORA-01852 seconds must be between 0 and 59
Description:
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.
Error List
Error List for the ‘ORA-01500 to ORA-02099’ Category
ORA-01853 seconds in day must be between 0 and 86399
Description:
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.
ORA-01854 julian date must be between 1 and 5373484
Description:
ORA-01854 julian date must be between 1 and 5373484
Cause:
An invalid Julian date was entered.
ORA-01855 AM/A.M. or PM/P.M. required
Description:
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.
ORA-01856 BC/B.C. or AD/A.D. required
Description:
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.
ORA-01857 not a valid time zone
Description:
ORA-01857 not a valid time zone
Cause:
An incorrect time zone code was specified for the NEW_TIME function.
ORA-01858 a non-numeric character was found where a numeric was expected
Description:
ORA-01858 a non-numeric character was found where a numeric was expected
Cause:
The input data to be converted using a date format model was incorrect. The input data did not contain a number where a number was required by the format model.
ORA-01859 a non-alphabetic character was found where an alphabetic was expected
Description:
ORA-01859 a non-alphabetic character was found where an alphabetic was expected
Cause:
The input data to be converted using a date format model was incorrect. The input data did not contain a letter where a letter was required by the format model.
ORA-01860 week of year must be between 1 and 53
Description:
ORA-01860 week of year must be between 1 and 53
Cause:
A week number outside the range 1 to 53 was specified.
ORA-01861 literal does not match format string
Description:
ORA-01861 literal does not match format string
Cause:
Literals in the input must be the same length as literals in the format string (with the exception of leading white space). If the “FX” modifier has been toggled on, the literal must match exactly, with no extra white space.