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
I'm not 100% sure I'm understanding your requirements, but this query:
select id from datetest where date_in not between '2006-09-05' and
'2006-09-21' and date_out not between '2006-09-05' and '2006-09-21';
should do exactly as you want for getting id3 if I'm understanding
the requirements
