Posting Yak Master
Posted - 10/08/2012 : 03:51:06
| Hello all,
I have a table (SQL Server 2008 R2) with 2 datetime fields, like:
StartDate - EndDate
Now I have a query with 2 variables, Date1 and Date2.
How can I know if there is an overlapping between these dates?
For example I have to check if the range between Date1 and Date2
is inside (also for one second) between StartDate and EndDate in the table.
How can I accomplish this?