troubleshooting Question

Convert Seconds to HH:MM:SS

Avatar of jjrr007
jjrr007 asked on
Oracle Database
18 Comments1 Solution11016 ViewsLast Modified:
Hello experts,

I have a column that has seconds in it.  I want to write something in my select statement that will convert this to HH:MM:SS?  Please advise.  

This answer is needed urgently! Thanks for your time.

P.S.  If this is of any help, this is what I have so far.
(Column1/3600) this would give me hours.  Then I need the integer function in Oracle (which I only know in MS SQL).  So it would be something like  
INT(Column1/3600)||":" ||
((INT(Column1/3600)) - (Column1/3600)/60) || ":" ||
INT(((INT(Column1/3600)) - (Column1/3600)/60)) - ((INT(Column1/3600)) - (Column1/3600)/60)

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 18 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros