OraFAQ Forum: SQL & PL/SQL » Average of date in days,hours,minutes format

Home » SQL & PL/SQL » SQL & PL/SQL » Average of date in days,hours,minutes format

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

Average of date in days,hours,minutes format [message #36683]

Wed, 12 December 2001 02:23

Manjunath
Messages: 9
Registered: July 2000

Junior Member

Hello,
I need to take the average(date1 - date2) in days, hours,minutes format. Can anybody help out.

Appreciate the needful and thanks in advance.
Manjunath

----------------------------------------------------------------------

Report message to a moderator

Re: Average of date in days,hours,minutes format [message #36690 is a reply to message #36683]

Wed, 12 December 2001 16:13

SAlapati
Messages: 12
Registered: November 2001

Junior Member

Check out TOM's solution at

http://osi.oracle.com/~tkyte/Misc/DateDiff.html

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	Rebuild index online, ORA-01031
Next Topic:	calling stored procedure from onchange event in javascript

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 21 05:28:24 CDT 2026