Wednesday, 22 January 2014

How to get total number of days in current month

How to get total number of days in current month



Show the first date of the current month:-

select  dateadd(dd,1-day(getdate()),getdate()) as FirstDateOfFirstMonth

Show the first date of the next month:-

select  dateadd(m,1,dateadd(dd,1-day(getdate()),getdate())) as FirstDayofSecondMonth

Show the total Number of days in the current month:-

select   datediff(dd, dateadd(dd,1-day(getdate()),getdate()),
dateadd(m,1,dateadd(dd,1-day(getdate()),getdate()))) as TotalNumberofday

select  dateadd(dd,1-day(getdate()),getdate()) as FirstDateOfFirstMonth,
dateadd(m,1,dateadd(dd,1-day(getdate()),getdate())) as FirstDayofSecondMonth
,datediff(dd, dateadd(dd,1-day(getdate()),getdate()),

dateadd(m,1,dateadd(dd,1-day(getdate()),getdate()))) as TotalNumberofday

0 comments: