Find All Sundays between two dates in SQL server Using CTE

Tutorialsrack 04/06/2019 SQL

In this article, we will learn how to find all the Sundays between two given dates in SQL Server using CTE(Common Table Expression).

Here is the code to find all the Sundays between two dates in SQL Server using CTE.

declare @DateFrom DateTime ='2019-01-01',
            @DateTo DateTime = '2019-01-31'
;WITH CTE(dt)
AS
(
      Select @DateFrom
      Union All
      Select DATEADD(d,1,dt)FROM CTE
      Where dt<@DateTo
)
select 'Sunday' as 'Day Name',dt as 'Sunday Date' from CTE
where DATENAME(dw,dt)In('Sunday');

I hope this article will help you to understand how to find all the Sundays between two given dates in SQL server.

Share your valuable feedback and help us to improve. If you find anything incorrect, or you want to share more information about the topic discussed above. please post your comment at the bottom of this article. Thank you!

Related Posts