Kbase P109577: 4GL: Error (223) is generated calling the DATETIME-TZ function.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/10/2005 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.x
SYMPTOM(s):
4GL: Error (223) is generated calling the DATETIME-TZ function.
** Incompatible data types in expression or assignment. (223)
Attempting to compile the code:
DEFINE VARIABLE dtzVar AS DATETIME-TZ NO-UNDO.
dtzVar = DATETIME-TZ(NOW,0,120).
CAUSE:
When passing three input parameters to the DATETIME-TZ function, the first input parameter must be of DATE data type. The code above passes the NOW function as the first input parameter to the DATETIME-TZ . The result returned by the NOW function is NOT of the required DATE data type. It is a DATETIME-TZ data type.
FIX:
When passing three input parameters to the DATETIME-TZ function, make sure that the first input parameter is a DATE data type value.