Kbase P33702: Result of STRING(TIME,'HH:MM') function does not display cor
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/07/2003 |
|
Status: Unverified
SYMPTOM(s):
Result of STRING(TIME,'HH:MM') function does not display correctly
Time is displayed as 'HH::M' instead of 'HH:MM'
CAUSE:
The string value was stored in a character variable or field with a format of 'XX:XX'.
But the output of STRING(TIME,'HH:MM') already contains a colon, so what happens is that a string "HH:MM" is formatted using the 'XX:XX' format, which results in 'HH::M' being returned.
FIX:
Change the display format to 'X(5)', or remove it entirely.