Kbase P134872: ADD-INTERVAL function doesn't set TIME properly
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/2/2009 |
|
Status: Unverified
SYMPTOM(s):
ADD-INTERVAL function is not setting TIME correctly
ADD-INTERVAL function sets TIME to 00:00:00.00+0100
Error occurs when converting seconds to datetime-tz
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
Bug# OE00174291
FIX:
To overcome this problem, replace the ADD-INTERVAL function with the following parameters:
my-datetime-tz = ADD-INTERVAL(DATETIME-TZ(01/01/1970), 1220518822, "seconds").