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

  • June 24, 2014 at 11:16 am

    #1724415

    Sean Lange (6/24/2014)

    Mr. Kapsicum (6/24/2014)

    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.

    You discovered one of those (un)documented features. When doing math against a datetime value it will use days. The correct way is to use DATEADD.

    It comes down to the underlying storage of the datetime value. You can add days by adding integer values to the function and it acts just as if you used DATEADD(DAY,10,GETDATE()). This doesn't work with new DATE or DATETIME2 data types.