A19483 2

[ Pobierz całość w formacie PDF ]
.2 176 Oracle7 Server Messages01800 01899: The Date FunctionORA 01836 hour conflicts with seconds in dayCause The wrong hour was specified with seconds in the day.If an hour is specifiedwith seconds past midnight (SSSSS), it must be the hour in which the secondsvalue falls.Action Remove the hour value from the date specification or specify the correct hourfor the seconds past midnight.ORA 01837 minutes of hour conflicts with seconds in dayCause A date specification contained both minutes of the hour and seconds in the daybut the values did not correspond.If both minutes in the hour (MI) andseconds past midnight (SSSSS) are specified, the minutes value must be theminute in which the seconds value will occur.Action Remove the minutes value from the date specification or enter the correctminute value for the specified seconds value.ORA 01838 seconds of minute conflicts with seconds in dayCause A date specification contained both seconds of the minute and seconds in theday 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 secondspast midnight value (SSSSS) will fall.Action Remove the seconds of the minute value from the date specification or enter avalue that corresponds to the given seconds in the day.ORA 01839 date not valid for month specifiedCause The day of the month specified in the date is invalid for the given month.Theday of the month (DD) must be between 1 and the number of days inthe month.Action Enter a valid day of the month for the specified month.ORA 01840 input value not long enough for date formatCause The data to be converted to date format was incomplete; the date formatpicture was longer than the input data.Action Either add more input or shorten the date picture format, then retrythe operation.Oracle7 Server Messages 2 17701800 01899: The Date FunctionORA 01841 (full) year must be between 4713 and +9999Cause A date specified a year that is not in the valid date range.A valid date is anydate 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 4Cause 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 monthCause A date specified an invalid month.Valid months are: January December, forformat 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 52Cause An invalid value was specified for the week of the year in a date.Week of theyear (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 5Cause An invalid value was specified for the week of the month in a date.Week of themonth (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 weekCause 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 DAction Enter a valid day of the week value in the correct format.2 178 Oracle7 Server Messages01800 01899: The Date FunctionORA 01847 day of month must be between 1 and last day of monthCause The day of the month listed in a date is invalid for the specified month.The dayof 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) mustbe 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 12Cause An invalid hour was specified for a date using the 12 hour time format.If a12 hour format code (HH or HH12) is used, the specified hour must bebetween 1 and 12.Action Enter an hour value between 1 and 12.ORA 01850 hour must be between 0 and 23Cause An invalid hour was specified for a date using the 24 hour time format.If the24 hour format code (HH24) is listed, the specified hour must be between 0and 23.Action Enter an hour value between 0 and 23.ORA 01851 minutes must be between 0 and 59Cause An invalid minute value was specified in a date.Minutes must be between 0and 59.Action Enter a minute value between 0 and 59.ORA 01852 seconds must be between 0 and 59Cause An invalid seconds value was specified in a date.Seconds must be between 0and 59 if the seconds format code (SS) is used.Action Enter a seconds value between 0 and 59.Oracle7 Server Messages 2 17901800 01899: The Date FunctionORA 01853 seconds in day must be between 0 and 86399Cause An invalid value for seconds in the day was specified in a date.Seconds mustbe 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 5373484Cause An invalid Julian date was entered.Action Correct and retry.ORA 01855 AM/A.M.or PM/P.M.requiredCause A date specification contained a meridian indicator format code but a validmeridian 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 validmeridian 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.requiredCause A date specification contained a BC/AD format code but a valid BC/ADindicator was not specified.If one of the BC/AD format codes, BC/AD orB.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 zoneCause 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 expectedCause The input data to be converted using a date format model was incorrect.Theformat model expected a number but found a non numeric character.Action Check the input data and the date format model to make sure the elementsmatch in number and type, then retry the operation.2 180 Oracle7 Server Messages01800 01899: The Date FunctionORA 01859 a non alphabetic character was found where a letter was expectedCause The input data to be converted using a date format model was incorrect.Theformat model expected a letter but found a non alphabetic character.Action Check the input data and the date format model to make sure the elementsmatch in number and type, then retry the operation.ORA 01860 week of year must be between 1 and 53Cause 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 stringCause Literals in the input string must be the same length as the literals in the formatstring, except for the leading white space characters [ Pobierz całość w formacie PDF ]