Home 2018 March SQL Puzzle: SQL Advance Query – Count total number of Working Days between Two Dates

SQL Puzzle: SQL Advance Query – Count total number of Working Days between Two Dates

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

Check the below input data and expected output for counting the total number of working days between given Two Dates.

Input Dates:

Required Output:

Solution:

Please try the different solution for this puzzle and share it via comment...

Anvesh Patel
SQL Server: Script to find the list of Startup ProceduresSQL Puzzle: SQL Advance Query – Generate a Random number in the range of Fifty
Comments: 2
  1. VINUTNA
    May 22, 2018 at 11:21 am

    declare @startdate date = ‘2018-01-01’
    declare @EndDate date = ‘2018-01-31’
    declare @working_days int = 0
    while (@startdate <= '2018-01-31')
    begin
    select @working_days = case when DATENAME(weekday, @startdate) IN ('Saturday', 'Sunday') then @working_days
    else @working_days +1
    end
    select @startdate = dateadd(day,1,@startdate)
    end
    select @working_days

    ReplyCancel
  2. HIC
    May 3, 2019 at 10:29 am

    PL/SQL:
    with wd(wday) as (
    select to_date(‘01.01.2018’, ‘dd.mm.yyyy’) from dual
    union all
    select wday + 1 from wd where wday < to_date('31.01.2018', 'dd.mm.yyyy')
    )
    select count(wday)
    from wd
    where to_char(wday, 'd') not in (1, 7);

    ReplyCancel

Leave a Reply

CAPTCHA

*

Anvesh Patel
Anvesh Patel

Database Engineer

March 1, 2018 2 Comments SQL Puzzle, , , , , , , , , ,