Getting the amount of overlap when using OVERLAPS

From: Tony Wasson <ajwasson(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Getting the amount of overlap when using OVERLAPS
Date: 2005-09-22 20:44:35
Message-ID: 6d8daee305092213441275804a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Given 2 date ranges, the overlaps functions returns TRUE or FALSE. I
want to find the # of days that are overlapping. Is there a "built in"
way to do this? Should I just write a function to do it?

For instance, this example overlaps, but I want to know how much does
it overlap?

SELECT (DATE '2001-02-16', DATE '2001-12-21') OVERLAPS
(DATE '2001-10-30', DATE '2002-10-30');

Thanks in advance!
Tony Wasson

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hannes Dorbath 2005-09-22 21:39:39 Re: Need for java based web admin tool
Previous Message Emi Lu 2005-09-22 20:40:55 Re: Questions about Rollback - after insert, update,