Hi,<br /><br />How can i find the number of days in the intersection of 2 date interval?<br />For example: <br />1st
interval:(10.01.2007, 20.01.2007)<br />2nd interval: (13.01.2007, 21.01.2007)<br />The intersection dates are:
13,14,15,16,17,18,19,20 <br />The result is: 8<br /><br />How can i find the result, 8 in an sql query without using
CASEstatements?<br /><br />Table columns are id PK, date1 date, date2 date.<br /><br />Thanks for all your help.<br
/><brclear="all" /><br />Suha<br /><br /><br />