Home Forums SQL Server 2005 Administering add 10 years to getdate RE: add 10 years to getdate

  • June 24, 2014 at 11:02 am

    #1724405

    SELECT DATEADD(YEAR,10,GETDATE()), This will add 10 Years to the current date.

    For ref: http://msdn.microsoft.com/en-IN/library/ms186819.aspx

    Moreover, the Query you provided I.e SELECT GETDATE()+10 will add 10 Days to current date.

    Can anyone please explain this.?

    Thanks in advance.