How can I determine in SQL Server if a dateTime range overlaps another

by

You can do like this

declare @T table (ID int, startDateTime datetime, endDateTime datetime)

insert into @T values
(  1 , '2010-01-01 10:30:00' , '2010-01-01 11:00:00'),
(  2 , '2010-01-01 10:30:00' , '2010-01-01 11:30:00'),
(  3 , '2010-01-01 11:00:00' , '2010-01-01 11:30:00'),
(  4 , '2010-01-01 11:00:00' , '2010-01-01 12:00:00'),
(  5 , '2010-01-01 11:30:00' , '2010-01-01 12:00:00')

declare @startDateTime datetime
declare @endDateTime datetime


set @startDateTime="2010-01-01 11:00:00"
set @endDateTime="2010-01-01 11:30:00"

select *
from @T
where
  startDateTime < @endDateTime and
  endDateTime > @startDateTime

More Related Contents:

  1. Comma separated results in SQL
  2. T-SQL stored procedure that accepts multiple Id values
  3. Understanding PIVOT function in T-SQL
  4. Calculate running total / running balance
  5. How do I escape a percentage sign in T-SQL?
  6. Using RegEx in SQL Server
  7. List of all index & index columns in SQL Server DB
  8. How do you count the number of occurrences of a certain substring in a SQL varchar?
  9. Find index of last occurrence of a sub-string using T-SQL
  10. Hidden Features of SQL Server
  11. SQL Server 2008 Empty String vs. Space
  12. Preserving ORDER BY in SELECT INTO
  13. SQL Server: combining multiple rows into one row
  14. Query to list all stored procedures
  15. SQL Server: Index columns used in like?
  16. WHERE clause on SQL Server “Text” data type
  17. Return all possible combinations of values on columns in SQL
  18. SQL Server error on update command – “A severe error occurred on the current command”
  19. Recursive sum in tree structure
  20. Multiple Column Pivot in T-SQL
  21. Joining multiple tables returns NULL value
  22. Which join syntax is better?
  23. Compute MD5 hash of a UTF8 string
  24. LPAD in SQL Server 2008
  25. How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?
  26. How do I remove non-breaking spaces from a column in SQL server?
  27. SQL SERVER – Understanding how MIN(text) works
  28. Pivot multiple columns based on one column in SQL Server
  29. @@ERROR and/or TRY – CATCH
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment