Kbase P127859: WRITE-XML method produces XML file having date format YMD even though the session startup parameter
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/23/2008 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
SYMPTOM(s):
XML file contains values with date format YMD even though the session startup parameter has DMY specified
Temp-table WRITE-XML method writes date field using YMD even though ABL startup parameter uses DMY
CAUSE:
This is expected behavior and is the consequence of data mapping from ABL DATE data type to the XML schema data type.
FIX:
OpenEdge ABL DATE data type maps to XML 'date', DATETIME and DATETIME-TZ map to XML 'dateTime' type, etc.
WRITE-XML method looks into the temp-table fields data types and when it finds 'DATE' data type maps it to the XML date which uses ISO8601 format.
Therefore, the ABL session date format startup parameter does not affect the date format to be used with WRITE-XML method.