Kbase P105089: TIME function does not accept parameters
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/07/2005 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0x
SYMPTOM(s):
Cannot use TIME function to convert string reprensentation of time to an integer value
Cannot use TIME function to extract time portion of DATETIME(-TZ) datatype.
** Unable to understand after -- "... TIME. ". (247)
** Unable to understand after -- "<string>". (247)
CAUSE:
The documentation is confusing.
The description implies the TIME function supports one or more arguments, where it supports none.
FIX:
To extract the time portion of a DATETIME(-TZ), use the MTIME function.
Note that MTIME will return the time in milliseconds.