Find last day, First day, Current, Prevoius, Next month in SQl Server

SQL SERVER – Find Last Day of Any Month – Current Previous Next


DECLARE @mydate DATETIME
SELECT @mydate = GETDATE()
declare @day int
declare @LDay int
SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@mydate)),@mydate),101) ,
'Last Day of Previous Month'
UNION
SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@mydate)-1),@mydate),101) AS Date_Value,
'First Day of Current Month' AS Date_Type
UNION
SELECT CONVERT(VARCHAR(25),@mydate,101) AS Date_Value, 'Today' AS Date_Type
UNION
SELECT CONVERT(VARCHAR(25), DATEADD(dd,-(DAY(DATEADD(mm,1,@mydate))),DATEADD(mm,1,@mydate)),    101) ,
'Last Day of Current Month'
UNION
SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,@mydate))-1),DATEADD(mm,1,@mydate)),101) ,
'First Day of Next Month'

union
--DECLARE @date DATETIME
--SELECT @date = GETDATE()

 select CONVERT(VARCHAR(25), DAY(DATEADD(dd,-(DAY(DATEADD(mm,1,@mydate))),DATEADD(mm,1,@mydate))),    101),
'Last day'



sql.PNG

Next Recommended Reading Get Day of Week in SQL Server