Home 2018 November SQL Puzzle: SQL Advance Query – Get the Last Sunday of Previous Week

SQL Puzzle: SQL Advance Query – Get the Last Sunday of Previous Week

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

Check the below input date and expected output to find the last Sunday of the previous week in SQL Server.

Input Date: ‘2018-04-15’

Expected Output:

Solution:

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

Anvesh Patel
SQL Server: Script to find the Size of IndexesSQL Server: Script to find the Largest Object of a Database
Comments: 3
  1. Dinesh
    November 22, 2018 at 7:17 am

    ;
    WITH CTE
    As
    (Select DateAdd(Week,-1,@MyDate) As MyDate
    Union All
    Select DateAdd(Day,1,MyDate)
    From CTE
    Where MyDate<@MyDate)
    Select * From CTE
    Where DateName(DW,MyDate)='Sunday' And MyDate<@MyDate

    ReplyCancel
  2. HIC
    April 8, 2019 at 5:57 pm

    SELECT NEXT_DAY(SYSDATE – 8, ‘воскресенье’)
    FROM dual;

    ReplyCancel
  3. Nikhil Bhosale
    August 14, 2019 at 9:14 am

    Declare @date date = ‘2019-08-18’;
    Declare @day int;
    Declare @diff int;
    SELECT @day = DATEPART(WEEKDAY, @date);
    Set @diff = @day-1;

    SELECT DATEADD(day, -@diff, @date) AS LastSundayDate

    ReplyCancel

Leave a Reply

CAPTCHA

*

Anvesh Patel
Anvesh Patel

Database Engineer

November 19, 2018 3 Comments SQL Puzzle, , , , , , , , , ,