How do I exclude Weekend days in a SQL Server query?

by

When dealing with day-of-week calculations, it’s important to take account of the current DATEFIRST settings. This query will always correctly exclude weekend days, using @@DATEFIRST to account for any possible setting for the first day of the week.

SELECT *
FROM your_table
WHERE ((DATEPART(dw, date_created) + @@DATEFIRST) % 7) NOT IN (0, 1)

More Related Contents:

  1. Get first day of week in SQL Server
  2. Get dates from a week number in T-SQL
  3. Date conversion and culture: Difference between DATE and DATETIME
  4. Turning a Comma Separated string into individual rows
  5. Calculate running total / running balance
  6. When should I use semicolons in SQL Server?
  7. How to get Time from DateTime format in SQL?
  8. Parse JSON in TSQL
  9. Get size of all tables in database
  10. Fuzzy matching using T-SQL
  11. List of all index & index columns in SQL Server DB
  12. Replace duplicate spaces with a single space in T-SQL
  13. SQL Server: Isolation level leaks across pooled connections
  14. How do I use the CONCAT function in SQL Server 2008 R2?
  15. How can sanitation that escapes single quotes be defeated by SQL injection in SQL Server?
  16. Scheduled run of stored procedure on SQL server
  17. SQL Server ORDER BY date and nulls last
  18. SQL Server variable columns name?
  19. How to: Create trigger for auto update modified date with SQL Server 2008
  20. What is the Oracle equivalent of SQL Server’s IsNull() function?
  21. SQL Recursive CTE: Finding objects linked by property
  22. PRINT statement in T-SQL
  23. T-sql – determine if value is integer
  24. Convert decimal time to hours and minutes
  25. SQL Query Where Column = ” returning Emoji characters 🎃 and 🍰
  26. FOR JSON PATH results in SSMS truncated to 2033 characters
  27. How Can I Detect and Bound Changes Between Row Values in a SQL Table?
  28. Is there an “IF EXISTS” test for a linked server?
  29. Date serial in SQL?
  30. SQL Server stored procedure return code oddity

Leave a Comment