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

GeetaMMay 22 2012 — edited May 22 2012

Hi

I would like to convert seconds to hours -

I have tried the below two -

 select to_char(to_date(176400,'SSSSS'),'HH:MI:SS') from dual;

 SELECT NUMTODSINTERVAL (176400, 'minute') FROM DUAL;

Regards

This post has been answered by sb92075 on May 22 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 19 2012

Added on May 22 2012

#pl-sql, #plsql, #sql, #sql-developer

6 comments

1,710 views