RE: Time Problem

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

-----Original Message-----
From: waseem altaf [mailto:buboo@xxxxxxxxxxxx]
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 you@xxxxxxxxxxxxxx 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 leave-oracle-1796914O@xxxxxxxxxxxxx