BIP - Date DataType

About

All about the date data type with BI Publisher

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.


Powered by ComboStrap