Kbase P109984: Why does my DATETIME-TZ variable have the incorrect time?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/10/2005 |
|
Status: Unverified
GOAL:
Why does my DATETIME-TZ variable have the incorrect time?
FACT(s) (Environment):
OpenEdge 10.x
FIX:
When the following code is executed, the time part of the DATETIME-TZ function does not match the result shown by the NOW function:
MESSAGE NOW SKIP DATETIME-TZ(TODAY,TIME) VIEW-AS ALERT-BOX.
The incorrect time value returned from the DATETIME-TZ function is due to the fact that when the DATETIME-TZ function is called with two parameters it expects the date and the time in milliseconds. The TIME function returns the current time in seconds and not milliseconds. If you replace the call to the TIME function with a call to the MTIME function, the results will be as you expect.