RE: Time Problem

select to_char(sysdate,'HH:MM:SS') from dual;

-----Original Message-----
From: waseem altaf [mailto:[email protected]]
Sent: Tuesday, January 21, 2003 5:21 AM
To: Oracle
Subject: [oracle] Time Problem


hi all 
i have a two date field . i subtract a one field from an other and multiply
by 24 it give hour and result like 8.53 and so on.
but i want the result as 8:34 how i do that? 
mean how i convert the 8.53 hour into 8(h):53(m)
thanks

_____________________________________________________________
Get 100% private, FREE email for life!
Visit http://inbox.com.pk

_____________________________________________________________
Select your own custom email address for FREE! Get [email protected] w/No
Ads, 6MB, POP & more! http://www.everyone.net/selectmail?campaign=tag

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to %%email.unsub%%.

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.




---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].