BI Publisher (MOSC)

MOSC Banner

Formatting bipext:infTimetToStr

edited Jul 13, 2015 10:02AM in BI Publisher (MOSC) 1 commentAnswered

Hi

The following function is being used to convert UNIX timestamp to the required format, however it's understood that the returned value is a string and is formatted in a US date format.

<?bipext:infTimetToStr(END_T,3)?>

It is fetching us date as mm/dd/yyyy hh:mi:ss (example: 04/30/2015 07:01:23).

However, our requirement is to show the date as dd/Mon/yyyy hh:mi:ss (example: 30/Apr/2015 07:01:23) format.

So to achieve that we are using:

<?xdoxslt:format_date(bipext:infTimetToStr(END_T,3),'dd-mm-yyyy hh:mi:ss','mm/dd/yyyy hh:mi:ss',$_XDOLOCALE, $_XDOTIMEZONE)?>

But its throwing error, am i doing any syntex mistake and is there an way to represent it in following format: dd/mm/yyyy hh:mi:ss

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