8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Overlapping Date Ranges


KHIZAR said...

HELLO GUYS NEED HELP
I HAVE TO CALCULATE WORKING DAYS OF AGENT THE DATA IS LOOK LIKE THIS
FROM TO
12/04/2007 42526 08/01/2008 4220139117037
30/08/1999 35361 30/12/2004 4220139117037
13/05/2005 42526 12/04/2007 4220139117037
31/10/2005 43411 01/09/2009 4220139117037
29/05/2007 46089 01/09/2009 4220139117037
08/01/2008 47442 01/09/2009 4220139117037

Tim... said...

Hi.

A quick Google resulted in this discussion. Seems like a good starting point.

https://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:185012348071

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.