SQL Server 2005 Using DateAdd to add a day to a date

Question

How do I in SQL Server 2005 use the DateAdd function to add a day to a date

Answer 1

Use the following function:

DATEADD(type, value, date) 

• date is the date you want to manipulate

• value is the integere value you want to add (or subtract if you provide a negative number)

• type is one of:

  • yy, yyyy: year
  • qq, q: quarter
  • mm, m: month
  • dy, y: day of year
  • dd, d: day
  • wk, ww: week
  • dw, w: weekday
  • hh: hour
  • mi, n: minute
  • ss or s: second
  • ms: millisecond
  • mcs: microsecond
  • ns: nanosecond

SELECT DATEADD(dd, 1, GETDATE()) will return a current date + 1 day

http://msdn.microsoft.com/en-us/library/ms186819.aspx