SQL: Date Utility

[sql]

DECLARE @date_Bing DATETIME SELECT @date_Bing = GETDATE()

[sql]

SELECT CONVERT(nvarchar(20), GETDATE(), 101) AS Today, MONTH(GETDATE()) AS CurrentMonth, MONTH(CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@date_Bing)),@date_Bing),101)) AS PreviousMonth, CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@date_Bing)+DAY(CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@date_Bing)),@date_Bing),101))-1),@date_Bing),101) as FirstDayOfPreviousMonth, CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@date_Bing)),@date_Bing),101) as LastDayOfPreviousMonth, CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@date_Bing)-1),@date_Bing),101) AS FirstDayOfCurrentMonth, CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,@date_Bing))),DATEADD(mm,1,@date_Bing)),101) as LastDayOfCurrentMonth GO