Home » SQL & PL/SQL » SQL & PL/SQL » Average of date in days,hours,minutes format
Average of date in days,hours,minutes format [message #36683] Wed, 12 December 2001 02:23 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Aug 19 22:37:32 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.