Date / Time

From: Sajid Iqbal <siqbal_at_vianetworks.co.uk>
Date: Tue, 10 Jul 2001 05:38:22 -0700
Message-ID: <F001.003454E1.20010710052609@fatcity.com>

Hello All

I want to display the "time elapsed" between two dates - in days, hours, minutes and seconds.

If I do "select date1 - date2", the result is : 12.0194907

Is there a function that will turn the number of days into something more legible? Ideally i'd like to do ;

"to_char(12.0194907,'DD:HH:MI:SS')" but obviously that won't work. Is there a solution other than writing a complex function myself which will have to * by 24, / by 60 and substr etc to get the different bits of the number?

Please CC any replies directly to me at siqbal_at_vianetworks.co.uk

Thanks in advance,
Saj.

--

Sajid Iqbal
Database Team Leader

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sajid Iqbal
  INET: siqbal_at_vianetworks.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jul 10 2001 - 07:38:22 CDT