getdate() - 1 Year

• Cnu2010

  SSC Enthusiast

  Points: 126

  More actions

  August 27, 2009 at 10:07 am

  #103809

  In SQL Server 2005 how to get sysdate - 1 year

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  August 27, 2009 at 10:17 am

  #1045662

  Hi ,

  getdate() will give you the current datetime then

  see BOL (books online) for the Dateadd statement

  ---

  
  Clear Sky SQL
  My Blog[/url]

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  August 27, 2009 at 10:19 am

  #1045666

  Use Books On Line and lookup the Date and Time Functions (Transact-SQL)

  and read this

  https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]