| Subject | RE: [firebird-support] Query using a range in where/having clause? |
|---|---|
| Author | Steffen Heil |
| Post date | 2004-06-07T19:18:14Z |
Hi
UserStart and UserEnd)
What about (ScheduleStart < UserEnd) and (ScheduleEnd > UserStart) ?
Regards,
Steffen
> ((ScheduleStart < UserStart) and (ScheduleEnd > UserEnd)) OR(ScheduleStart BETWEEN UserStart and UserEnd) OR (ScheduleEnd BETWEEN
UserStart and UserEnd)
What about (ScheduleStart < UserEnd) and (ScheduleEnd > UserStart) ?
Regards,
Steffen