Time Problem
waseem altaf <[email protected]> Tue, 21 Jan 2003 02:21:18 -0800 (PST)
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-841631-2003.01.21-10.22.06--gcdod-oracle#[email protected]> |
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 protected].