Check if a time is between two times (time DataType)

by

I suspect you want to check that it’s after 11pm or before 7am:

select *
from MyTable
where CAST(Created as time) >= '23:00:00' 
   or CAST(Created as time) < '07:00:00'

More Related Contents:

  1. How to create a specific SQL Server stored procedure? [closed]
  2. SQL Server dynamic PIVOT query?
  3. SQL Server – Best way to get identity of inserted row?
  4. Should I use != or for not equal in T-SQL?
  5. How to update two tables in one statement in SQL Server 2005?
  6. SQL Server Process Queue Race Condition
  7. Is the NOLOCK (Sql Server hint) bad practice?
  8. SQL – Subtracting a depleting value from rows
  9. OR is not supported with CASE Statement in SQL Server
  10. How to set variable from a SQL query?
  11. Compare DATETIME and DATE ignoring time portion
  12. Easiest way to populate a temp table with dates between and including 2 date parameters
  13. T-SQL: Selecting Column Based on MAX(Other Column)
  14. unresolved reference to object [INFORMATION_SCHEMA].[TABLES]
  15. SQL dot notation
  16. Split function in SQL Server 2008
  17. T-SQL How to create tables dynamically in stored procedures?
  18. What is the difference between SQL, PL-SQL and T-SQL?
  19. What is the equivalent of ‘describe table’ in SQL Server?
  20. Create a SQL query to retrieve most recent records
  21. How can I group by date time column without taking time into consideration
  22. Update query using Subquery in Sql Server
  23. T-SQL: checking for email format
  24. Database Naming Conventions by Microsoft?
  25. Convert date to YYYYMM format
  26. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  27. Is there a quick way to check if ANY column is NULL?
  28. SQL Convert Week Number to Date (dd/MM)
  29. SQL query for parent-child chain
  30. T-SQL Conditional Order By

Leave a Comment