BIP - Date DataType

Card Puncher Data Processing

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.





Discover More
Card Puncher Data Processing
BIP - Formatting

See The RTF standard includes a command that enables you to “keep a paragraph with the next paragraph.” This command prevents a page break between the paragraph for which it is enabled and the...
Card Puncher Data Processing
Business Intelligence Publisher

BIP is a highly scalable reporting engine capable of generating pixel perfect reports from multiple data sources in multiple formats via multiple delivery channels. Bi Publisher is based on the Apache...
Obiee 10g Obiee Dashboard Prompt Bip Parameter Relation
OBIEE 10G - BIP report integration

Oracle BI Publisher creates highly formatted, printable reports. Oracle BI Publisher is integrated with Oracle Business Intelligence, and you access Oracle BI Publisher from the : Oracle BI Answers,...
Time - Time representation (Moment, Instant)

This section goes over the representation of time in a scalar way versus in a collection way (ie time series) Time is basically a numeric counter that increases over time. An instant in time can be represented...



Share this page:
Follow us:
Task Runner