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

IF...

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...