Solution1 (by richcb) is very good, but i want to show you little trick. Of course, you can use
DATEADD[
^] function, but see below example:
DECLARE @myDate DATETIME
SET DATEFORMAT dmy;
SET @myDate = '07/04/2013'
SELECT @myDate AS MyDate1, DATEADD(dd,1,@myDate) AS MyDate2, @myDate + 1 AS MyDate3
The same you can achieve using simply
+ 1
.