On Fri, Jan 26, 2007 at 12:02:24 +0200,
Achilleas Mantzios <[EMAIL PROTECTED]> wrote:
> Suha,
> the function is the number of days in the
> maximum of the two start dates , untill , minimum of the two end dates
> interval.
> But in postgresql (7.4.15 at least) there is no MIN(date,date),MAX(dat
Στις Παρασκευή 26 Ιανουάριος 2007 11:50, ο/η A. Kretschmer έγραψε:
> am Fri, dem 26.01.2007, um 11:39:03 +0200 mailte Suha Onay folgendes:
> > Hi,
> >
> > How can i find the number of days in the intersection of 2 date interval?
> > For example:
> > 1st interval: (10.01.2007, 20.01.2007)
> > 2nd
am Fri, dem 26.01.2007, um 11:39:03 +0200 mailte Suha Onay folgendes:
> Hi,
>
> How can i find the number of days in the intersection of 2 date interval?
> For example:
> 1st interval: (10.01.2007, 20.01.2007)
> 2nd interval: (13.01.2007, 21.01.2007)
> The intersection dates are: 13,14,15,16,17,
Hi,
How can i find the number of days in the intersection of 2 date interval?
For example:
1st interval: (10.01.2007, 20.01.2007)
2nd interval: (13.01.2007, 21.01.2007)
The intersection dates are: 13,14,15,16,17,18,19, 20
The result is: 8
How can i find the result, 8 in an sql query without usi
