Home 2018 May SQL Puzzle: Get the list of Monday of a Month

SQL Puzzle: Get the list of Monday of a Month

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

Check the below input data and expected output to get the list of Monday of an April 2018

Expected Output: Get the list of Monday of April 2018

Solution:

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

Anvesh Patel
SQL Puzzle: Find the upcoming Birthday for a Next MonthDBRND listed by feedspot in the Category of Top 30 SQL Server Blogs
Comments: 4
  1. VINUTNA
    May 6, 2018 at 2:47 pm

    declare @x date = ’04-01-2018′
    while (@x <= '04-30-2018')
    begin
    select @x=dateadd(day,1,@x)
    if datepart(dw,@x)=2
    begin
    select @x
    end
    end

    ReplyCancel
  2. Dpan
    April 15, 2019 at 9:27 am

    declare @dateOfApril date,@dayOfApril nvarchar(max)
    set @dateOfApril=’2018-04-01′;
    While (@dateOfApril<'2018-05-01')
    begin
    set @dayOfApril=DATENAME(dw,@dateOfApril)
    if(@dayOfApril='Monday')
    Begin
    print @dateOfApril;
    End
    set @dateOfApril=DateAdd(dd,1,@dateOfApril);
    end

    ReplyCancel
  3. HIC
    April 27, 2019 at 1:48 pm

    WITH days(mon) AS (
    SELECT next_day(to_date(‘31.03.2018’, ‘dd.mm.yyyy’), ‘monday’) as mon from dual
    UNION ALL
    SELECT mon + 7 FROM days
    WHERE mon + 7 <= to_date('01.05.2018', 'dd.mm.yyyy')
    )
    SELECT * FROM days;

    ReplyCancel
  4. Keith Fernandes
    October 27, 2019 at 2:17 pm

    declare @start date = ‘2018-04-01’
    declare @end date = ‘2018-04-30’
    ;with cte as
    (
    select @start as date
    union all
    select DATEADD(DAY,1,date) as date1 from cte
    where DATEADD(DAY,1,date) <= @end
    )
    select * from cte where DATENAME(DW,date) = 'Monday'

    ReplyCancel

Leave a Reply

CAPTCHA

*

Anvesh Patel
Anvesh Patel

Database Engineer

May 4, 2018 4 Comments SQL Puzzle, , , , , , , , , ,