Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert seconds to hours and minutes

BobH90024Sep 16 2009 — edited Jan 18 2013
Hi,

I have a column which stores elapsed time in seconds. I'd like to convert it to hours and minutes.

E.G.

126 seconds = 2:06. I can't seem to find anything with a search.

Thanks in advance.
This post has been answered by 666352 on Sep 16 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2013
Added on Sep 16 2009
#time
4 comments
19,888 views