BI Publisher (MOSC)

MOSC Banner

Convert Unix Time stamp (epoch) to date format (dd-mm-yyyy HH:mi:ss) in BI Publisher 10g

edited Jun 25, 2013 4:52AM in BI Publisher (MOSC) 1 commentAnswered
Hi all,

I need to convert epoch date to dd-mm-yyyy format in BI publisher 10g template designing.
For example: '1379442600' is the epoch date coming from Unix system in xml to BI publisher, i need to change same to dd-mm-yyyy format.
Do BI publisher has any function to convert this if not then please let me know how to change that.
 i need to convert the epoch date in my BI Publisher RTF template, i am not firing any sql query in my DB to fetch the XML rather the xml is provided to me and the provider cannot change there sql for my requirement. Please let me know if this is possible in BI Publisher template designing coding in XSLT/XDO.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center