RE: Calculating # of days,hours,mins

From: Kevin Martin <kevin.martin_at_catapultsystems.com>
Date: Fri, 19 May 2000 09:35:42 -0500
Message-Id: <10502.106102@fatcity.com>

Sorry for the late reply, but I would like to thank Rajendra Jamadagni and Brian MacLean for their contributions on this topic. It worked great!
-km

-----Original Message-----

From: Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L Sent: 5/12/00 4:44 PM
Subject: RE: Calculating # of days,hours,mins

select record_id, to_char(sysdate-record_insert_timestamp, 'DD "Days", HH24
"Hours",
SELECT ROUND(rec_timestamp-SYSDATE) || ' Days '

|| TO_CHAR(TO_DATE(ABS(((rec_timestamp-SYSDATE) - ROUND(rec_timestamp-SYSDATE))*86400), 'SSSSS'), 'HH24') || ' Hours '

|| TO_CHAR(TO_DATE(ABS(((rec_timestamp-SYSDATE) - ROUND(rec_timestamp-SYSDATE))*86400), 'SSSSS'), 'MI') || ' Minutes '

|| TO_CHAR(TO_DATE(ABS(((rec_timestamp-SYSDATE) - ROUND(rec_timestamp-SYSDATE))*86400), 'SSSSS'), 'SS') || ' Seconds ' FROM dual

e.g.
1 SELECT ROUND(SYSDATE+40/25-SYSDATE) || ' Days ' 2 || TO_CHAR(TO_DATE(ABS(((SYSDATE+40/25-SYSDATE) - ROUND(SYSDATE+40/25-SYSDATE))*86400), 'SSSSS'), 'HH24') || ' Hours ' 3 || TO_CHAR(TO_DATE(ABS(((SYSDATE+40/25-SYSDATE) - ROUND(SYSDATE+40/25-SYSDATE))*86400), 'SSSSS'), 'MI') || ' Minutes ' 4 || TO_CHAR(TO_DATE(ABS(((SYSDATE+40/25-SYSDATE) - ROUND(SYSDATE+40/25-SYSDATE))*86400), 'SSSSS'), 'SS') || ' Seconds ' 5* FROM dual
SQL> / ROUND(SYSDATE+40/25-SYSDATE)||'DAYS'||TO_CHAR(TO_DATE(ABS(((SYSDATE+40/2 5-SY
SDAT

2 Days 09 Hours 36 Minutes 00 Seconds

SQL> HTH
Raj
--

Author: Jamadagni, Rajendra
INET: rajendra.jamadagni_at_espn.com

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 Fri May 19 2000 - 09:35:42 CDT