| Subject | Re: [firebird-support] Query using a range in where/having clause? |
|---|---|
| Author | Daniel Rail |
| Post date | 2004-06-07T22:36:51Z |
Hi,
At June 7, 2004, 16:18, Steffen Heil wrote:
it wouldn't be covered by any of the 3 conditions that I mentioned?
I'm just curious and can't currently think of one.
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)
At June 7, 2004, 16:18, Steffen Heil wrote:
>> ((ScheduleStart < UserStart) and (ScheduleEnd > UserEnd)) ORCan you give me an example where I would need this condition and that
> (ScheduleStart BETWEEN UserStart and UserEnd) OR (ScheduleEnd BETWEEN
> UserStart and UserEnd)
> What about (ScheduleStart < UserEnd) and (ScheduleEnd > UserStart) ?
it wouldn't be covered by any of the 3 conditions that I mentioned?
I'm just curious and can't currently think of one.
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)