My Blog List

hotinit.com. Powered by Blogger.

Search This Blog

First Date and Last Date Of First Month And Previous Month

Monday, 6 June 2011


DECLARE @mydate DATETIME

SELECT @mydate = GETDATE()


SELECT CONVERT(VARCHAR(25),DATEADD(MONTH , -1,DATEADD(dd,-(DAY(@mydate)-1),@mydate)),101) AS FirstDateOfLastMonth
SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@mydate)),@mydate),101)  as LastDayOfPreviousMonth
SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@mydate)-1),@mydate),101) AS FirstDateOfCurrentMonth
SELECT CONVERT(VARCHAR(25),@mydate,101) AS  'PresentDateOfCurrentMonth-Today'





No comments:

Post a Comment

 

Blogger news

Blogroll

Most Reading

8.6/10