| |
- Causa
- Sintaxe inválida para DATE, TIME OU TIMESTAMP
O tamanho ou string representando um DATE, TIME ou TIMESTAMP value não está conforme os formatos válidos.
The value can contain one of the following:
- For a host variable, the position number of the input host variable.
If the position number cannot be determined, a blank is displayed.
- For a character string constant, the character string constant.
The maximum length that is displayed is the length of SQLERRM.
- 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'.
- Ação do sistema
- O comando não pode ser executado.
- Resposta ao Desenvolvedor
- 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.
SQLSTATE: 22007
© Copyright IBM Corp.
|
| |
