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

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

sql sql-server tsql date dateadd

DECLARE @MyDate datetime-- ... set your datetime's initial value ...'DATEADD(d, 1, @MyDate)

sql sql-server tsql date dateadd

Try following code will Add one day to current date

select DateAdd(day, 1, GetDate())

And in the same way can use Year, Month, Hour, Second etc. instead of day in the same function

CodeHunter