Oracle Convert Seconds to Hours:Minutes:Seconds

sql oracle plsql plsqldeveloper
user1430989 picture user1430989 · Jun 12, 2012 · Viewed 126.8k times · Source

I have a requirement to display user available time in Hours:Minutes:Seconds format from a given total number of seconds value. Appreciate if you know a ORACLE function to do the same. I'm using Oracle.

Thank you for your time.

Answer

vogash picture vogash · Oct 23, 2012

Try this one. Very simple and easy to use

select to_char(to_date(10000,'sssss'),'hh24:mi:ss') from dual;

Related questions

How to create cursor inside procedure body in plsql

I want create cursor inside procedure body dynamically also i have to use for loop instead of below code. i did the dynamic cursor but i cannot use the for loop. PROCEDURE myprocedure AS LV_TEST_CUR SYS_REFCURSOR; LV_…

Read More
How to check the timezone of oracle pl/sql developer

Where do I check the timezone of oracle pl/sql developer.Can someone help please

Read More
Timezone conversion in PLSQL

I need to convert the sysdate and time to a particular timezone like EST. I can't assume my current time zone. How to convert this in plsql? Please help me.

Read More