List:General Discussion« Previous MessageNext Message »
From:spacemarc Date:October 29 2006 10:14am
Subject:Check date interval in SELECT
View as plain text  
Hi
I have 3 fields like this:

id  date_in          date_out
1   2006-09-05   2006-09-10
2   2006-09-15   2006-09-20
3   2006-09-25   2006-09-30

Example: if I have an time interval like '2006-09-05' and '2006-09-21',
I have to search, in the same time, only the records that not included
in time interval and
that they are different is from date_in that from date_out.
In the example above, I would have to obtain only last record (id 3).

Thanks in advance

-- 
http://www.spacemarc.it
Thread
Check date interval in SELECTspacemarc29 Oct
  • Re: Check date interval in SELECTDavid Thole30 Oct
  • Re: Check date interval in SELECTDavid Thole30 Oct