Convert Unix Time stamp (epoch) to date format (dd-mm-yyyy HH:mi:ss) in BI Publisher 10g
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.