OraFAQ Forum: SQL & PL/SQL » To convert second into hours,minutes,seconds

Home » SQL & PL/SQL » SQL & PL/SQL » To convert second into hours,minutes,seconds

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

To convert second into hours,minutes,seconds [message #9658]

Wed, 26 November 2003 22:41

Jayasri
Messages: 28
Registered: July 2000

Junior Member

Hi,
How to convert second into hours:Minutes:Seconds using a single select statement in oracle 8i

Thanks
Jayasri.

Report message to a moderator

Re: To convert second into hours,minutes,seconds [message #9659 is a reply to message #9658]

Wed, 26 November 2003 23:52

Cheeku
Messages: 17
Registered: November 2003

Junior Member

Hi,
I guess the above query should work. In case of any clarifications revert back.
*****************************************************
select trunc(12600/3600) hours, trunc(mod(12600, 3600)/60) minutes , mod(mod(12600, 3600), 60)seconds from dual
******************************************************

Report message to a moderator

Re: To convert second into hours,minutes,seconds [message #9660 is a reply to message #9659]

Thu, 27 November 2003 01:04

Jayasri
Messages: 28
Registered: July 2000

Junior Member

Hi,
Thanks a lot. It's working perfect.

Regards
Jayasri

Report message to a moderator

Re: To convert second into hours,minutes,seconds [message #9663 is a reply to message #9658]

Thu, 27 November 2003 16:44

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

For up to 86400 seconds try:
<pre style="color: navy;">SQL> var seconds number
SQL> exec :seconds := 12345

SQL> SELECT TO_CHAR(TRUNC(SYSDATE) + (:seconds/86400),'HH24:MI:SS') AS time FROM dual;

TIME
--------
03:25:45</pre>

Report message to a moderator

Previous Topic:	HELP with select statement
Next Topic:	insert multiple rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 07:39:58 CDT 2024