Ansicht
Dokumentation

SQL0181 - Value in date, time, or timestamp string not valid. ( OS/400 )

ABAP Short Reference   General Data in Customer Master  
This documentation is copyright by IBM.


Message : SQL0181
Value in date, time, or timestamp string not valid.

Message Long Text :

Cause . . . . . : The string representation of a date, time or timestamp value is not in the acceptable range. &2 is either the character string constant that is not valid or the column or host variable that contained the string. If the name is *N, then the value was found in an expression specified in the statement. If the value was found in a host variable, then the host variable number is &1. The proper ranges for date, time, or timestamp values are as follows:
-- The range for years is from 0001 to 9999. For date formats *MDY, *YMD, *DMY, and *JUL, the year must be in the range 1940 to 2039.
-- The range for months is from 1 to 12.
-- The range for days is from 1 - 30 for April, June, September, and November, from 1 - 28 for February and from 1 to 31 for all other months. In a leap year, the range for February can be from 1 to 29.
-- The range for days in a Julian date is from 001 to 366 for a leap year or 001 to 365 days for all other years.
-- The range for hours is from 0 to 24. If the hour is 24, then the other parts of the time values must be zeros. If the time format is USA, then the hour cannot be greater than 12.
-- The range for minutes is from 0 to 59.
-- The range for seconds is from 0 to 59.
-- The range for microseconds is from 0 to 999999.
Recovery . . . : Ensure that the date, time, or timestamp value conforms to the ranges for the data type it represents. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


rdisp/max_wprun_time - Maximum work process run time   Vendor Master (General Section)  
This documentation is copyright by IBM.

Length: 3249 Date: 20240419 Time: 203347     sap01-206 ( 2 ms )