Start Date and End date of the month June 27, 2012 Get link Facebook X Pinterest Email Other Apps SELECT Convert(datetime , CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(Getdate())-1), Getdate() ),103),103) AS Date_Value SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))Declare @FromDate datetime Comments
Comments
Post a Comment