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 QUERYDECLARE @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@
Well, thats kind the idea of the question, isn't it? You just explained the answer that was already there.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP