BIP - Date DataType

> Data Visualization (vis|viz|graphic|image) > Business Intelligence Publisher

1 - About

All about the date data type with BI Publisher

Advertising

3 - Format

3.1 - 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

3.2 - 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")?>
Advertising

4 - Sort

The date is sorted as a text within the storage format.