BI Publisher (MOSC)

MOSC Banner

Unable to convert Epoch Time stamp to canonical date format.

edited Oct 7, 2013 11:50PM in BI Publisher (MOSC) 6 commentsAnswered
Hi All,

We have integrated Oracle BRM and Oracle BIP for billing and invoice generation. The time field say for example 'END_T' which is coming from BRM is in UNIX epoch time stamp format.

<END_T>1381084200</END_T>

Now while generating the invoice from BIP we need to convert this time stamp to DD-MON-YYYY format.
We are using the below mentioned function in BIP template to convert the time stamp.


<?format-date:(xdoxslt:ora_format_date_offset('1970-01-01', //invoice/BILLINFO/END_T div 86400, ‘+‘)) ; 'DD-MON-YYYY'?>


Its generating us the date in desired format: 06-Oct-2013 but we are working in Australian time zone which is 5Hrs 30Mins more than GMT.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS BI Publisher Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center