Consultor Eletrônico



Kbase P123419: User-defined Function returning DATETIME does not cast DATETIME-TZ back automatically
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   4/16/2007
Status: Unverified

FACT(s) (Environment):

OpenEdge 10.x

SYMPTOM(s):

User-defined function has DATETIME return-type

RETURN statement refers to a DATETIME-TZ variable or function returning DATETIME-TZ

RETURN statement in user defined function or method '<name>' is not type compatible with the function or method definition. (2782)

CAUSE:

This is a known issue being investigated by Development

FIX:

Workaround:
Use intermediate DATETIME variable in the function