Home Forums Article Discussions Article Discussions by Author Discuss content posted by Bernabe Diaz t-sql first last day date of the month RE: t-sql first last day date of the month

  • December 1, 2009 at 5:20 am

    #1085702

    Hi,

    I think the Last date can be font by

    SELECT @r=dateadd(day,-(datepart(day,@d)),dateadd(mm,1,@d))

    No need to use

    SELECT @r=dateadd(day,-(datepart(day,dateadd(mm,1,@d))),dateadd(mm,1,@d))

    Because, datepart(day,@d) and datepart(day,dateadd(mm,1,@d)) will return the same result. Then why to add one month to @d?