Add business days to date in SQL without loops

by

This is better if anyone is looking for a TSQL solution. No loops, no tables, no case statements AND works with negatives. Can anyone beat that?

CREATE FUNCTION[dbo].[AddBusinessDays](@Date date,@n INT)
RETURNS DATE AS 
BEGIN
DECLARE @d INT;SET @d=4-SIGN(@n)*(4-DATEPART(DW,@Date));
RETURN DATEADD(D,@n+((ABS(@n)+@d-2)/5)*2*SIGN(@n)-@d/7,@Date);
END

More Related Contents:

  1. Current date in Oracle Db
  2. How to return only the Date from a SQL Server DateTime datatype
  3. Comparing date ranges
  4. Oracle’s default DATE format
  5. Get the week start date and week end date from week number
  6. How to determine the number of days in a month in SQL Server?
  7. Group by month and year in MySQL
  8. How to convert an integer (time) to HH:MM:SS::00 in SQL Server 2008?
  9. Difference between datetime and timestamp in sqlserver? [duplicate]
  10. How do you do date math that ignores the year?
  11. Select data from date range between two dates
  12. Find closest date in SQL Server
  13. Query comparing dates in SQL
  14. Getting date list in a range in PostgreSQL
  15. How to calculate the number of “Tuesdays” between two dates in TSQL?
  16. PostgreSQL: how to convert from Unix epoch to date?
  17. Get month name from date in Oracle
  18. SQL “between” not inclusive
  19. Check if current date is between two dates Oracle SQL
  20. Comparing with date in Oracle sql
  21. sqlite select with condition on date
  22. how to remove time from datetime
  23. Check whether string is a date Postgresql
  24. How to compare dates in datetime fields in Postgresql?
  25. Postgresql query between date ranges
  26. Getting results between two dates in PostgreSQL
  27. Subtracting Dates in Oracle – Number or Interval Datatype?
  28. Query for count of distinct values in a rolling date range
  29. Select query with date condition
  30. Date serial in SQL?

Leave a Comment