Get year calendar with months name and number of days in sql server - Free Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server,WCF,Entity framework snippets and tutorial

Get year calendar with months name and number of days in sql server

In this article I am going to explain how to get year calendar with months name and number of days in sql server.



Description:

I want to get the year calendar i.e. month name with how many days in a month.



Implementation:
Run the below given query in Sql server to get the year calendar:

declare @StartDate DATE
declare @Enddate DATE

set @StartDate = '2016-01-01'
set @Enddate   = '2016-12-31'
 
;with months (date)
AS
(
    SELECT @StartDate
    UNION ALL
    SELECT DATEADD(month,1,date)
    from months
    where DATEADD(month,1,date)<=@Enddate
)
select DATEPART(mm ,Date) as [Month Number],DATENAME(mm ,Date) as [Month Name]            
            ,DATEPART(dd,DATEADD(day,-1,DATEADD(MONTH,+1,date))) as [Number of Days In Month]
            ,DATEPART(yy ,Date) as [Year] from months




What do you think about this article?

If you found this article useful, please share and follow on Facebook, Twitter, Google Plus and other social media websites. To get free updates subscribe to newsletter. Please put your thoughts and feedback in comments section.

Share this

Share on FacebookTweet on TwitterPlus on Google+


EmoticonEmoticon