Get all the date of current year or particular year, below is the scrip to get the record from sql server.
- Declare @Year AS INT =DATENAME(YYYY, getdate()) ;
- declare @FromDate datetime=DATEADD(yyyy, @Year - 1900, 0),@ToDate datetime=DATEADD(yyyy, @Year - 1900 + 1, -1);
-
- WITH Dates (DateNo) AS (
- SELECT DATEADD(DAY, DATEDIFF(DAY, 0, @ToDate) - DATEDIFF(DAY, @FromDate, @ToDate), 0)
- UNION ALL SELECT DATEADD(DAY, 1, DateNo)
- FROM Dates
- WHERE DATEADD(DAY, 1, DateNo) <=@ToDate)
-
- SELECT DateNo as [Date],DATENAME(month, DateNo) as [Month Name],DATENAME(DW, DateNo) as [Day Name]
- FROM Dates
-
- option (maxrecursion 365);