Last Day First Day of Previous Current Next Month

LastDayFirstDayOfPreviousCurrentNextMonth.sql

DECLARE @mydate DATETIME
SELECT @mydate = CONVERT(VARCHAR(25),GETDATE(),101)

SELECT DATEADD(dd, -(DAY(@mydate)), @mydate) AS DateValue, 'Last Day of Previous Month' AS DateType
UNION ALL
SELECT DATEADD(s, -1, DATEADD(mm, DATEDIFF(m, 0, @mydate),0)) AS DateValue, 'Last Day of Previous Month' AS DateType
UNION ALL
SELECT DATEADD(dd, -(DAY(@mydate)-1), @mydate) AS DateValue, 'First Day of Current Month' AS DateType
UNION ALL
SELECT DATEADD(m, DATEDIFF(m, 0, @mydate), 0) AS DateValue, 'First Day of Current Month' AS DateType
UNION ALL
SELECT @mydate AS DateValue, 'Today' AS DateType
UNION ALL
SELECT DATEADD(dd, -(DAY(DATEADD(mm, 1, @mydate))), DATEADD(mm, 1, @mydate)) AS DateValue, 'Last Day of Current Month' AS DateType
UNION ALL
SELECT DATEADD(s, -1, DATEADD(mm, DATEDIFF(m, 0, @mydate)+1, 0)) AS DateValue, 'Last Day of Current Month' AS DateType
UNION ALL
SELECT DATEADD(dd, -(DAY(DATEADD(mm, 1, @mydate))-1), DATEADD(mm, 1, @mydate)) AS DateValue, 'First Day of Next Month' AS DateType
UNION ALL
SELECT DATEADD(s, -1, DATEADD(mm, DATEDIFF(m, 0, @mydate)+2, 0)) AS DateValue, 'Last Day of Next Month' AS DateType