About
All about the date data type with BI Publisher
Articles Related
Format
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")?>
Sort
The date is sorted as a text within the storage format.