Listing All Days of a Year in SQL Server

Hello to everyone,

In this article, I will try to give information about listing all the days of a year in SQL Server.

In SQL Server, in some cases you may want to list all the days of a year.

You can easily do this using the code below.

WITH CTEHistoryList
AS (SELECT CAST('2021-01-01' AS DATETIME) Dates
    UNION ALL
    SELECT Dates + 1
    FROM CTEHistoryList
    WHERE Dates + 1 <= '2021-12-31')
SELECT Dates
FROM CTEHistoryList
OPTION (MAXRECURSION 0);

When you run the above code, you will see a result similar to the one below.

Listing All Days of a Year in SQL Server

As you can see, we have listed all the days of a year.

Good luck to everyone in business and life.

94 Views

Yavuz Selim Kart

I try to explain what I know in software and database. I am still improving myself by doing research on many programming languages. Apart from these, I am also interested in Graphic Design and Wordpress. I also have knowledge about SEO and Social media management. In short, I am a determined person who likes to work hard.

You may also like...

Don`t copy text!