BI Publisher (MOSC)

MOSC Banner

BI Publisher Assistance

edited Nov 6, 2019 2:13PM in BI Publisher (MOSC) 5 commentsAnswered ✓

I need to format a time field to Gregorian format. My data is hhmmss currently and I need to get it to hh:mm:ss.

I have been trying to substring the field and concantenate where needed. this is what I have

<?xdofx:if  length(BeginningHhMmSs_ID18) = 5 then

concat ( substr(BeginningHhMmSs_ID18,1,1),':')

else concat( substr(BeginningHhMmSs_ID18,1,2),':')

end if?>

and this is what is returned

0.00083333333333333333

Can someone explain to me how this is possible and what I can do to fix it? I am working on a RTF template.

Tagged:

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