Re: Date subtraction showing Day:Hour:Min:Sec format
From: Yves Noel <noel_at_omega.univ-lille1.fr>
Date: 5 Jan 1994 08:32:57 GMT
Message-ID: <2gdtvp$3ig_at_netserver.univ-lille1.fr>
Date: 5 Jan 1994 08:32:57 GMT
Message-ID: <2gdtvp$3ig_at_netserver.univ-lille1.fr>
In article <CJ4npv.13tt_at_empros.com>, btreuman_at_empros.com (Bob Treumann) writes:
|>
|>We need to do date subtraction to know how much time elapsed between
|>an event start and end time. We need to display it in days:hour:min:secs
|>Has anyone done this? Can you show me a script, or a PL*SQL procedure
|>to do it?
|>
|>The result of the calculation will be displayed on a forms4.0 screen.
|>
|>
|>Thanks in advance. =<:) ( do you remember tom terrific ? );
|>
|>
|>
Have you try the SQL*Plus command TIMING ? Perhaps it can respond to your
question. (SQL*PLus User's Guide and Reference page 6-72)
-
_/_/_/_/ _/_/_/_/ _/_/_/_/ _/_/_/_/ I use _/_/ _/_/ _/_/ _/_/ ORACLE v6.0.36.5.2 _/_/ _/_/ _/_/ _/_/ on _/_/_/_/ . _/_/_/_/ . _/_/ . _/_/_/_/ . DEC RISC ULTRIX v4.3 ------------------------------------------------------------------------------ Yves NOEL - Database Administrator Mail : Yves.Noel_at_univ-lille1.fr C.I.T.I. (batiment M4) Universite des Sciences & Technologies de Lille Phone : (33) 20.43.42.70 59655 Villeneuve d'Ascq Cedex - FRANCE Fax : (33) 20.43.66.25 ------------------------------------------------------------------------------Received on Wed Jan 05 1994 - 09:32:57 CET