Kbase P70052: 4GL Date Array fields have incorrect default format when displayed in SQL92.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/09/2010 |
|
Status: Verified
SYMPTOM(s):
4GL Date Array fields have incorrect default format when displayed in SQL92.
In SQL-92, 4GL Date fields show the date as being 9999-99-99 whereas 4GL Date Array fields show the date as 99/99/9999.
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
Bug# OE00101570
FIX:
Workaround:
To make the array the same as the Date field:
select DateField,TO_DATE(PRO_ELEMENT(DateArray,1,1)) from pub.table1;
or:
select DateField,TO_DATE(DateArray) from pub.table1;
or this, to make the Date field the same as the array:
select TO_CHAR(DateField,'mm/dd/yyyy'),PRO_ELEMENT(DateArray,1,1) from pub.table1;
or:
select TO_CHAR(DateField,'mm/dd/yyyy'),DateArray from pub.table1;