First and last day
How to get first day and last day of month ?
June 20th, 2015 3:00pm
DECLARE @mydate DATETIME
SELECT @mydate = GETDATE()
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),DATEADD(dd,-(DAY(DATEADD(mm,1,@mydate))),DATEADD(mm,1,@mydate)),101) ,
'Last Day of Current M
SELECT @mydate = GETDATE()
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),DATEADD(dd,-(DAY(DATEADD(mm,1,@mydate))),DATEADD(mm,1,@mydate)),101) ,
'Last Day of Current M
Free Windows Admin Tool Kit Click here and download it now
June 20th, 2015 3:06pm
First day
select DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE())+0, 0)
Last day
select DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE())+1, -1)
June 20th, 2015 3:18pm