Home Forums SQL Server 2005 T-SQL (SS2K5) DateAdd together with DateDiff RE: DateAdd together with DateDiff

  • May 10, 2012 at 8:01 pm

    #1486077

    Is this what you are looking for?

    declare @ThisDate datetime;

    set @ThisDate = '7/12/2009 0:00:00';

    select dateadd(yy, 1, DATEADD(MM, DATEDIFF(mm, 0, @ThisDate), 0))

    set @ThisDate = '8/12/2009 0:00:00';

    select dateadd(yy, 1, DATEADD(MM, DATEDIFF(mm, 0, @ThisDate), 0))

    set @ThisDate = GETDATE();

    select dateadd(yy, 1, DATEADD(MM, DATEDIFF(mm, 0, @ThisDate), 0))