M@N@ (4/28/2010)

---

Yes, you are right,The 'DATE' datatype is exists on SQL Server 2005/2008 but i told that in below QUERY

DECLARE @Today DATE

SELECT @Today = '01 DEC 2009'

SELECT @Today+1

SELECT @Today

IF use @Today as DATE datatype we will get error like

'Operand type clash: date is incompatible with int'

so if change Datatype DATE to DATETIME, then it will work and we will get Result

'2009-12-02 00:00:00.000'

Best Regards

M@N@