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

  • June 24, 2014 at 10:50 am

    #1724398

    river1 (6/24/2014)

    Hi,

    I want to add 10 years to the current date.

    select getdate()

    I made:

    select getdate() +10 but it does not work.

    Thank you

    Try:

    dateadd(year,10,getdate())