Storage

The date in the XML file must be specified in the canonical ISO date format.

The following format are supported:

• YYYY-MM-DD (example: 1997-10-24)
• YYYY-MM-DD HH24:MI:SS (example: 1997-10-24 12:00:00)
• YYYY-MM-DDTHH24:MI:SS.FF3TZH:TZM

Output

In BIP, you can use two formats :

• Native Windows word : not recommended
• Oracle format

Reference : Date Formatting

• With the xdo function

<?xdoxslt:sysdate("DD-MON-YYYY HH12:MI AM")?>