OraFAQ Forum: Forms » How can i compute time spent in my processing

Home » Developer & Programmer » Forms » How can i compute time spent in my processing

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can i compute time spent in my processing [message #80581]

Wed, 16 October 2002 18:45

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

Report message to a moderator

Re: How can i compute time spent in my processing [message #80586 is a reply to message #80581]

Thu, 17 October 2002 10:32

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

Report message to a moderator