Home » Developer & Programmer » Forms » How can i compute time spent in my processing
How can i compute time spent in my processing [message #80581] Wed, 16 October 2002 18:45 Go to next message
Susane
Messages: 27
Registered: September 2002
Junior Member
Hi!
Please help me compute the time spent in my processing. What i want to show the user is during processing i can show them the time consume from the start they processed the program until it was finished. Please help me..

thanks
Re: How can i compute time spent in my processing [message #80586 is a reply to message #80581] Thu, 17 October 2002 10:32 Go to previous messageGo to next message
Julie
Messages: 98
Registered: February 2002
Member
Save the datetime stamp at start and completion. Subtract the two. The result is in days, or fraction thereof. Multiple by 24 to get hours. Round the result.

select round(24 * (
to_date('10/01/2002 12:00:00', 'mm/dd/yyyy hh:mi:ss') -
to_date('10/01/2002 10:00:00', 'mm/dd/yyyy hh:mi:ss'))) dif from dual

DIF
---------
2
Re: How can i compute time spent in my processing [message #80588 is a reply to message #80581] Thu, 17 October 2002 10:52 Go to previous messageGo to next message
satish
Messages: 112
Registered: September 2000
Senior Member
Hi,
you can use
set timing on
before query, it will give u the time spent in processing and displays u the time after processing is done.
-Satish.
Re: How can i compute time spent in my processing [message #80611 is a reply to message #80586] Mon, 21 October 2002 01:24 Go to previous message
sane
Messages: 3
Registered: September 2002
Junior Member
thanks for the information it helps me.
Previous Topic: Form 6i question
Next Topic: How to create files in a part directory thru forms
Goto Forum:
  


Current Time: Tue Oct 19 20:18:04 CDT 2021