June 27, 2012

Start Date and End date of the month


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   

No comments:

Post a Comment