SQL SERVER – Query to Find First and Last Day of Current Month

reference:
http://blog.sqlauthority.com/2007/05/13/sql-server-query-to-find-first-and-last-day-of-current-month/


DECLARE @mydate DATETIMESELECT @mydate = GETDATE()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_TypeUNION
SELECT CONVERT(VARCHAR(25),@mydate,101) AS Date_Value, 'Today'AS Date_TypeUNION
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'GO
-----------------------------------------------------------
Sample used in my report

DECLARE @mydate DATETIME = Getdate()
declare @fromDate DATETIME
declare @toDate DATETIME
SELECT @fromDate=CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@mydate)-1),@mydate),101),@toDate=getdate()

SELECT FORMAT(@fromDate, 'M/d/yyyy') as FromDate_Value,FORMAT(@toDate, 'M/d/yyyy') as ToDate_Value