December 28, 2011

Get Start date of Current month

SELECT Convert(datetime , CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(Getdate())-1),' Getdate() ),103),103) AS Date_Value 

No comments:

Post a Comment