Hi to all,

1.

DECLARE @Today DATE

it wii not work but if you change datetype "DATE" to "DATETIME"

Then it will work

DECLARE @Today DATETIME

SELECT @Today = '01 DEC 2009'

SELECT @Today+1

SELECT @Today

2.

Directly we can't add integer value to date variable, by using DATEADD function we can add day(s)/year(s) to date variable.