- 1

Duration needs to be calculated in between two dates by excluding weekends and holidays

I have requirement to find the duration in minutes from two dates whose data type timestamp. need to calculate the duration by excluding weekends and holidays

17th Apr 2022, 6:06 AM
vijay
vijay - avatar
1 Antwort
0
Finding duration between datetimes is relatively easy by using built-in datediff functions. Subtracting weekends is a complicated computation that involves determining separately the number of Saturdays to subtract and the number of Sundays to subtract. Then removing holidays requires a set of cumbersome logical and mathematical rules, such that it might be easier to use a lookup table that lists all holiday dates. Also be cognizant of overlap so as not to doubly subtract holiday dates that fall on a weekend. I recommend searching the web for ideas. Then post your SQL query here if you need further specific help.
17th Apr 2022, 2:49 PM
Brian
Brian - avatar