DB2 SQL-Error: -180
SQLState: 22007
Short Description: THE DATE TIME OR TIMESTAMP VALUE IS INVALID
The length or string representation of a DATE, TIME, or TIMESTAMP value does not conform to any valid format. The value can contain one of the following: v For a host variable, the position number of the input host variable. If the position number cannot be determined, a blank is displayed. v For a character string constant, the character string constant. The maximum length that is displayed is the length of SQLERRM. v For a character column, the column name. If the column is a VIEW column and it has a corresponding base column, the VIEW column name is displayed. If the column is a VIEW column but it does not have a corresponding base column, a string of Â’*NÂ’ is displayed.Otherwise, value is a string of '*N'. System action: The statement cannot be executed. Programmer response: Correct the program to ensure the specified value conforms to the syntax of DATE, TIME, and TIMESTAMP. Refer to Chapter 2 of DB2 SQL Reference for a list of valid DATE and TIME formats.