Find First, Last Date of Previous and Next Month in SQL

Some time we required to find out the current date , first and last date of previous or next month. We can use below code for all these requirements.

This code return the First and last Date of previous month , Current date , last date of current month and first date of next month.

DECLARE @TODAY_DATE DATETIME;
SELECT
@TODAY_DATE = GETDATE();
SELECT
CONVERT(
VARCHAR(25),
DATEADD(
DD,
-(
DAY(@TODAY_DATE) -1
),
@TODAY_DATE
),
103
) AS DATE_,
'FIRST DATE OF PREVIOUS MONTH' AS DATE_NAME
UNION ALL
SELECT
CONVERT(
VARCHAR(25),
DATEADD(
DD,
-(
DAY(@TODAY_DATE)
),
@TODAY_DATE
),
103
) AS DATE_,
'LAST DATE OF PREVIOUS MONTH' AS DATE_NAME
UNION ALL
SELECT
CONVERT(
VARCHAR(25),
@TODAY_DATE,
103
) AS DATE_,
'TODAY DATE' AS DATE_NAME
UNION ALL
SELECT
CONVERT(
VARCHAR(25),
DATEADD(
DD,
-(
DAY(
DATEADD(MM, 1, @TODAY_DATE)
) -1
),
DATEADD(mm, 1, @TODAY_DATE)
),
103
) AS DATE_NAME,
'FIRST DATE OF NEXT MONTH'
UNION ALL
SELECT
CONVERT(
VARCHAR(25),
DATEADD(
DD,
-(
DAY(
DATEADD(MM, 1, @TODAY_DATE)
)
),
DATEADD(mm, 1, @TODAY_DATE)
),
103
) AS DATE_NAME,
'LAST DATE OF CURRENT MONTH' GO