BI Publisher (MOSC)

MOSC Banner

Convert time from seconds to hrs and minutes.

edited May 4, 2010 11:31AM in BI Publisher (MOSC) 1 commentAnswered
 Hi All,
I have a small question regarding printing of time in BI reports. I have a column in the tables indicating drive_time of a truck in seconds. But I want to show the time in hours and minutes in the report. 
I am trying to use oracle format mask, but its not working. 

<?format-date:C_TIME_H;'HH:MI:SS.FF3'?>


Any suggestion will be of great help


Thanks,
Sudheer

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