BIP - Date DataType

1 - About

All about the date data type with BI Publisher

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

4 - Sort

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


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap